[resolved] Splitting a file into multiple files -

[Anonymous]

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.

[Anonymous]

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

[Anonymous · Accepted solution]

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