I'm trying to check schema from a input file which has columns
and my validating schema is
if it doesn't match my condition it should through a message out saying this file schema is missing on so and so column
in the above example i don't have student id in my input file.
I tried the flow in the image but i'm getting a error message
in this job i created a metadata excel as a input in the first input box.
In this scenario i need to pick a file dynamically from the job
how can i do that?
The error message says Column9 is not a valid column in your schema. Can you resolve that issue? If not, can you show a screen shot of the details of your schema validator component?
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema