[resolved] Splitting a file into multiple files -

Anonymous — Thu, 04 Feb 2016 10:03:07 GMT

Hi All,
I have a requirement which I am not sure if is feasible to achieve using Talend.
I have an input file named as "FOOD_DETAILS" whose data need to be extracted and stored in multiple tables depending upon its content.
Content is something like this -
APPETIZERS
----------------
"TX","aaa","100","","","XXX"
"CA","bbb","101","","","XXA"
"NJ","ccc","102","","","XXB"
SNACKS
-----------
"100",,,,"abc","a111",,,
"101",,,,"ccc","b222",,,
I want to split this file into 2 named - APPETIZERS and SNACKS - containing the data present below their headings.
File-1 : APPETIZERS
"TX","aaa","100","","","XXX"
"CA","bbb","101","","","XXA"
"NJ","ccc","102","","","XXB"
File-2 : SNACKS
"100",,,,"abc","a111",,,
"101",,,,"ccc","b222",,,
Let me know if you need any further inputs on my requirement.
Help is much appreciated!
Thanks & Regards,
RB.

Re: [resolved] Splitting a file into multiple files -

Anonymous — Mon, 08 Feb 2016 05:11:23 GMT

Yes, It is possible. You have to use mediation perspective in order to achieve your requirements.

Re: [resolved] Splitting a file into multiple files -

Anonymous — Mon, 08 Feb 2016 06:30:18 GMT

You may use tmap and solve your problem.
This link may helpful
https://community.talend.com/t5/Design-and-Development/Split-file-by-column/td-p/86892

topic Re: [resolved] Splitting a file into multiple files - in Talend Studio

[resolved] Splitting a file into multiple files -

Re: [resolved] Splitting a file into multiple files -

Re: [resolved] Splitting a file into multiple files -