I have scenario which need to migrate from Abinitio to Talend.
Here we are getting source file as .txt and Pipe delimited with no header. And header is getting in another .dml file. Here we need to compare the value of first column first row with dml file and need to get the schema based on the value and at last we need to merge all this in single file.
Ex :
Sourec File:
A|Talend|DI|Migration
B|Abinitio|DI
C|12
Header File Data
If firtst column data equal to "A" then we need to get
From your description, do you want to modify the schema structure dynamically? Have you checked talend dynamic schema feature which allows you to design schema with an unknown column structure (unknown name and number of columns)?
