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.
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Learn how to publish your API Services to Talend Cloud
Find out aboutCloud Data Warehouse Trends for 2019