topic Dynamic Schema Creation for tfileinputdelimited in Talend Studio

Dynamic Schema Creation for tfileinputdelimited

Anonymous — Sat, 16 Nov 2024 03:54:29 GMT

Hello,

I am pivoting the data using tpivottocolumnsdelimited component and that pivoted output further i want to load into excel file.

tFileInputDelimited component asks for schema, but my schema would change(dynamic) as per pivoted columns generated in CSV file.

Can anyone guide me in creating schema at runtime using csv file?

I am using Talend Open Studio product, i do not have enterprise version's subscription.

Re: Dynamic Schema Creation for tfileinputdelimited

Anonymous — Mon, 09 Dec 2019 04:55:06 GMT

Hello,

Talend dynamic schema feature is only available in Talend subscription solution not open source, it allows you to design schema with an unknown column structure (unknown name and number of columns).
With community version, the schema must be defined at design time, before the job execution.

https://community.talend.com/t5/Design-and-Development/How-to-process-changing-data-structure/ta-p/2...

Best regards

Sabrina