unite more row fromfiles with differents schema in one unique txt file
hi to everyone i have a problem with my job in talend: every input file(txt file) have a different schema tFileInputDelimited1 tFileInputDelimited2 tFileInputDelimited3 tFileInputDelimited4 tFileInputDelimited5 ------------------------- tFileOutputDelimited1 in output i want an output file that have rows with different number of columns if i use tUnite but it's based on a common schema!! are there some components that i can use? help! thanx
Re: unite more row fromfiles with differents schema in one unique txt file
yes, but i think that i can't use a tMap because i want to take that schema for each file, for example the largest row have 50 columns, and then the second have 30...and then 4column..ecc if i change the schema of each file, in output for a file that have 4 columns i'll have the first 4 columns and then all the remaining rows until 50 it'll be empty like ;;;;;;;;;;; --but i don't want this example: FirstFile.txt A;talend;20080101;0; SecondFile.txt B;3;20070428;talend;myExample; ThirdFile.txt C;29929992;tom;jerry;20080104;9939939939;talend;44433222;0;004;john; FourthFile.txt D;24; FifthFile.txt E;24; MyOutputFile.txt A;talend;20080101;0; B;3;20070428;talend;myExample; C;29929992;tom;jerry;20080104;9939939939;talend;44433222;0;004;john; D;24; E;24;
thank y very much PS: i was thinking about this way, with the tUnite i can try to tell to talend that the separator is "|" but if i use this ";" like separator symbol ,Talend it will read all the rows of each file like one row because it can't find the separator and so the job is done!!! i tried to do this but the tUnite it doesn't permit me to link to himself more than one tFileInputDelimited,maybe because i didn't fix a common schema?!!!