topic Re: 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? in Talend Studio

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 — Sat, 16 Nov 2024 04:34:47 GMT

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.

Re: 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?

Anonymous — Wed, 25 Sep 2019 07:59:08 GMT

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/21702
Best regards
Sabrina

Re: 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 — Mon, 30 Sep 2019 11:09:56 GMT

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

Re: 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?

Anonymous — Tue, 01 Oct 2019 02:46:14 GMT

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