Hopefully it is clear from the subject what I want to do, but really I have multiple Oracle inputs that output to Excel, and I want every Type for the excel output to be "String". When I click Sync Columns, it of course, gives me all of the datatypes associated to the Oracle Input (Date, Dec, String etc.). I either want to be able to change the data type for the excel output to "String" all at once, or be able to sync just column name, Null-able, without syncing Type. What's the easiest way I could do this? (My data changes a lot and I have dozens of these, so saving generic schema is not an option here since I need specific header names)
Talend dynamic schema feature allows you to design schema with an unknown column structure (unknown name and number of columns).
Could you please have a look at this article about:TalendHelpCenter:How to process changing data structure?
Feel free to let us know if it is what you are looking for.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables