can someone tell how to process multiple files in Talend and store the output in a oracle table?? I tried using tfileList component but i was unable to insert data into table. My file extension is also ".unl" which no file related component is reading data.. So could someone help me with this??
Hi, Thanks for the replies. I should not change the file format as it is production environment.What ever the .unl files I get in the directory differed by a sequence number I should read them and process them and store the required fields in the oracle table as output. The data in the .unl file is pipe delimited (for example : 12345|active||P|hello) like this. But when I iterate the files in the directory its reading only first file and not reading other files. The sample file names in the soure directory will be like sample20161115_SOMECODE1_SEQNUMBER.unl sample20161115_SOMECODE2_SEQNUMBER.unl,etc So how can i iterate??I mean what filemask should i keep in tfilelist component?? Any help would be greatful
Hi, Thanx for the reply. But still my problem was not resolved. I have three files in a directory mon20161113_103_941462.unl mon20161113_103_941463.unl mon20161113_103_941464.unl But when I gave filemask as "mon20161113_103_*.unl" in tfilelist and in tfileinputdelimited I created metadata with mon20161113_103_941462.unl file. But when i run my job its showing 3 execs finished but when i see output the first file data is only stored 3 times but not 2 and 3 files. Please help me with this.
it mean - You have error somewhere also ;-) we of course can try to guess, but will be much better if You show Your Job ... much more easy without information, just trust me - it work! even with hundreds of files, sure simple error
Hi, We can't see the screenshot on our side. Could you attach it on the forum, please? That would be great. Screenshots works only if you drag&drop the image directly in the editor window. Best regards Sabrina
-- Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.