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

Four Stars

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

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!

Moderator

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

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

 

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch