Hi,
I'm new to Talend ETL and was wondering if anyone could tell me which components I need to use to parse a pipe delimited file as so:
Read through pipe delimited file and parse as follows:
If record_type = 1 then output field1 to table1.field1, field2 to table1.field2 etc
If record_type = 2 then output field1 to table2.field1, field2 to table2.field2 etc
If record_type = 3 then output field1 to table3.field1, field2 to table2.field2 etc
etc.....
If a tMap how do I use the expression, or is it a tFilter?
Any help and a simple heads-up to get me started will be much appreciated.
Many thanks
Andy
You want to use the tFileInputMSDelimited component. You will create record layouts for each record_type, and they will each have their own output from that component.
