Field transform with multiple date formats

Mohammad Dicetek · Dec 11th 2019, 8:02am

how to format data if one column data have multiple date formats
ex: mm/dd/yyyy and dd.mm.yyyy hh:mm:ss

chrisj · Feb 26th 2020, 5:01am

You could use a groovy field with IF condition

check if the source column value has a "/", if so format in the particular format and convert to a standard format like dd-mmm-yyyy
check if the source column value has a ".", if so format in the particular format and convert to a standard format like dd-mmm-yyyy