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

Four Stars

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

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?

Nine Stars

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

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?

--
Please give Kudos and mark topics as solved where appropriate.

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog