How to read a comma separated file with dynamic schema i.e., number of columns will vary in the source file in Talend open studio?

[vamsi_talend]

Hi Talend Group,

Can you please advise on how to read the comma separated file with dynamic schema where the number of the columns will vary in the subsequent files in Talend Open Studio? I have searched in few blogs but I did't get the right solution for my approach. Kindly suggest. Thanks alot.

[Anonymous]

Hello,

The dynamic schema feature is available in talend subscription solution. It allows you to design schema with an unknown column structure (unknown name and number of columns).

Here is a community article about:https://community.talend.com/t5/Design-and-Development/How-to-process-changing-data-structure/ta-p/2... 
Best regards
Sabrina

[vamsi_talend]

Thank You for your response, Sabrina. However, I'm looking for a solution to achieve in open studio.

[Anonymous]

Hello,

Could you please elaborate your case with an example with input and expected output values? In this way, we could look into it to see if there is any alternative solution in open studio.

Best regards

Sabrina