Dynamic Loading of Schema in tfileInputDelimited component

[Vaishi]

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.

[vikramk]

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.

[Vaishi]

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).

[Anonymous]

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