How to validate Excel Headers

Seven Stars

How to validate Excel Headers

I need to know if the Excel file which is being processed has header names same as per the expected sequence. If the header names are different I need to stop job with an error captured in tLogCatcher. If the header names are same as per the expected sequence then the file is supposed to be processed further.

 

@umeshrakhe  I referred the post: https://community.talend.com/t5/Design-and-Development/How-to-check-csv-header-names-are-valid/td-p/...


But tFileInputFullRow works for CSV file for Excel it prints garbage values. Is there a way in Talend to capture all headers of Excel File as a Single Row?

 

 

 

Five Stars

Re: How to validate Excel Headers

Excel will not give you all columns as a full row instead you have to parse
each sheet and convert them to csv, psv and flow the rest.

Using dynamic schema you directly read all columns the draft them in csv,
psv and then again follow rest of the post.

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

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog