topic Re: Dynamic Loading of Schema in tfileInputDelimited component in Talend Studio

Dynamic Loading of Schema in tfileInputDelimited component

Vaishi — Sat, 16 Nov 2024 01:08:38 GMT

Actual Input:

Name,Age,Employee,Student,Doctor

Ram,25,Yes,No,No

Sita,20,No,Yes,No

Output :

Name,Age,Occupation,Yes/No

Ram,25,Employee,Yes

Ram,25,Student,No

Ram,25,Doctor,No

Sita,20,Employee,No

Sita,20,Student,Yes

Sita,20,Doctor,No

When the input file header has extra occupations, how lo generate the output dynamically, without manually changing the schema in the tInputFileDelimited, etc...... components.

We were able to achieve this, through unpivotRow component, but the only challenge is, every time an occupation gets added up, we have to manually change the schema in all the components.

We tried

tSetDynamicSchema , but the column names are generic.

Re: Dynamic Loading of Schema in tfileInputDelimited component

vikramk — Tue, 10 Nov 2020 11:12:21 GMT

Hi @Vaishnavi Pradheep ,

You could try with dynamic schema available in tfileinputdelimited component to achieve your requirement. Please go through below url:

https://www.youtube.com/watch?v=zqEmdIb7dG4

Please let me know if it helps.

Re: Dynamic Loading of Schema in tfileInputDelimited component

Vaishi — Tue, 10 Nov 2020 16:51:56 GMT

Hi @Vikram Kumar

But this not available in the open studio. Also we are using the column names as well in the output(Employee, Student,Doctor).

Re: Dynamic Loading of Schema in tfileInputDelimited component

Anonymous — Wed, 11 Nov 2020 05:16:45 GMT

Hello,

The Dynamic schema feature is only available in Talend subscription solution, which allows you to design schema with an unknown column structure (unknown name and number of columns).

You can download a free trial product from here:

https://www.talend.com/free-trial/

Best regards

Sabrina