Verif Files and header files

[suzel404]

Hi all,

I receive some files contained in my folder INPUT_DATA every night

- FM_FOLDERS.csv

- FM_MATERIAL.csv

- FM_QUERIES.csv

- FM_STOCK.csv

- Territories.xls

- WorldVehicleData.xlxs

I need to make some controls before QV runs for each file :

- TEST 1 : Respect of the columns number (if I have 5 columns I can't have less or more thus it is an error of integration)

- TEST2 : Respect of the column label (if the label of column is STATUS_DATE it can't be DATE_STATUS thus it is an error of integration)

IF TEST 1 AND TEST 2 = OK => MOVE FILES TO ANOTHER FOLDER

IF TEST 1 AND TEST 2 = KO => TRACE ERROR IN FOLDER ERROR_INPUT_DATA

How can I achieve that automatically?

Thanks for your help,

Regards