Trying to validate schema which is 1st row only from a ecxel work book with multiple sheets and each sheet needs to have different schema checks

[Anonymous]

I'm trying to check schema from a input file which has columns 

first name 

lastname

empty

middlename

and my validating schema  is

first name

lastname

studentid

middlename

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?

[nfz11]

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?

[mildredtennyson]

The error message says the issue is in a Colum9 so you need to check whether this field has valid values; and it says nothing about student id in the input file. Would be useful to see print screens of your databases: please upload them to https://domyessay.onl.