Talend Schema, Mass change Column Data Type or similar effect on FileExcelOutput

Anonymous — Mon, 22 Jan 2018 23:17:50 GMT

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)

Thanks!

Re: Talend Schema, Mass change Column Data Type or similar effect on FileExcelOutput

Anonymous — Mon, 05 Feb 2018 03:39:38 GMT

Hello,

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.

Best regards

Sabrina

topic Re: Talend Schema, Mass change Column Data Type or similar effect on FileExcelOutput in Talend Studio

Talend Schema, Mass change Column Data Type or similar effect on FileExcelOutput

Re: Talend Schema, Mass change Column Data Type or similar effect on FileExcelOutput