Hi Team,
We have a large dataset that has around 2 million rows, in this dataset there are multiple datetime fields. Intially when loading data from S3 the datatype for all the fields are string. We need to convert the data type for respective fields. In the preview we see a set of records that dont have a single value for couple of columns, these columns are all datatime. When we set the date format for such columns it would give message that the format is not valid.
WE filtered the dataset small set of records to include records that have these values, but it would still show record that have empty dates in preview and would not apply the date format that is present in the fields.
Could anyone suggest a way to set the date format to columns that dont show dates in the preview.