Helllo, I have 5 CSV files (separator : , ) with the same structures but the last one haven't the same order of columns : example :
the columns of the Files number 1 2 3 4 like this :
Price |Date | Quantity |
The file number 5 is like this :
Date|Price| Quantity
so when i push the data of the 5 files i will have an error that the type are incorrect, and this is normal because he considerate the first column in the file number 5 is Price and not "Date " like in the others file
I tryed to detect columns to resolve the problem but nothing
Any idea please ?
Thank you