I am absolutely new to Talend and having a hard time figuring out how to parse a file whose layout changes based on a certain identifier.
in the example below schema/layout for RCID through RECORD_KEY does not vary but anything after that can vary based on the value of RCID
string(2) RCID ; ------ Fixed
string(1) CDGT ; ------ Fixed
string(1) TCND ; ------ Fixed
string(5) RECORD_KEY; ------ Fixed
if (RCID == "03")
Records in the input file may or may not be in the sorted order. In the example above RCID "02" appears before RCID "03". Please note record types 01-through 03 are part of the same record having the same key value "12345". I need to read the file and later aggregate it based on this key. Any ideas? I have searched this forum but did not find anything meaningful.
Does Talend allow Nested Schema definition? For example, if in the same group of records, if I want to say in TMPA that if it record type 01 then do this else if it is record type 02 then do this.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
This video focuses on different methods of adding metadata to a job in Talend Cloud
This video will show you how to add context parameters to a job in Talend Cloud
This video will show you how to run a job in Studio and then publish that job to Talend Cloud