topic Re: How to check multiple excel file format? in Talend Studio

How to check multiple excel file format?

Anonymous — Mon, 29 Oct 2018 09:30:38 GMT

Hi,

I am having excel file format as shown below:

and when file format is wrong like:

If City Code is not present in the file, it should be moved to Error directory.

My question is how can I handle such situation while working with more than one excel file iteration?

I am having problem with handling more than on excel file format. Similarly, if any of the column from the 4th row is missing or there is not header on the 4th row, the file should move to Error folder.

Thanks,

Dhara

Re: How to check multiple excel file format?

fdenis — Tue, 30 Oct 2018 14:31:00 GMT

read your excel as text with header and limit first and last column to get data to check.
then check your rules to valide format.
then of it's the good formant, load them normally.
if not then you can use tWarn to generate error.

Re: How to check multiple excel file format?

Anonymous — Mon, 12 Nov 2018 12:32:50 GMT

How can I check rules to validate file format?