Forum Discussion
elimey
Helper I
Helper IImport from CSV gives error on Date conversion
I am trying to import a csv file, I have two issues: - first, all the columns are being imported as Text. Even with "Always detec data type" option on, everything is imported as text. What can I do?...
Change the data type when importing to text and not date.
Then, you can handle the column with a transformation to extract date into a new column.
The error will be displayed in the row for those dates that are invalid.
You can then copy the query and filter rows in new query for only those with errors.
You can filter the original query those rows with no errors.