I am not able to read a csv file using “Read CSV” operator. It throws an error message as “Invalid format”
However I was able to open other CSV files earlier. The only difference between the CSV file which threw error and the other one is the date format.
File read successful - had date format in DD.MM.YYYY
File read failure - had date format in DD/MM/YYYY.
How can I read CSV with the date format as is. Even if I have to make manipulation to the data, I have to read to make changes. Is there any other approach to read CSV file and store it as datatable?