topic Re: Handling files with Dynamic Columns in Talend Studio

Handling files with Dynamic Columns

AManohar — Fri, 15 Nov 2024 22:27:48 GMT

Hi,

Our Input file has 5 mandatory fields and can have up to 3 dynamic fields.

Some files may not have any dynamic columns at all and may have only the 5 mandatory fields.

Is it possible to verify whether the input file has min of 5 mandatory fields.

Since we can't enable "Check each row structure against schema", is there an alternate way to validate the mandatory fields alone.

We can't look for not null because field 4 and 5 is nullable.

Thank you.

Banupriya — Fri, 14 Oct 2022 07:37:55 GMT

Hi,

You can select the columns with Dynamic schema in datatype.

Thanks

Anonymous — Mon, 17 Oct 2022 09:11:26 GMT

The solution worked for me thanks to the community and the members for the solution.