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.
Watch the recorded webinar!
Accelerate your data lake projects with an agile approach
Create systems and workflow to manage clean data ingestion and data transformation.
Introduction to Talend Open Studio for Data Integration.