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.
