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