Hi I am new to alteryx. I have a very huge dataset with lots of Date data.
| DateA | DateB | DateC | DateD | ... | | |
| 2023-01-31 | 2023-01-31 | 2023-01-31 | 2023-01-31 | | | |
| - - | - - | - - | - - | | | |
| 2023-02-02 | 2023-02-02 | 2023-02-02 | 2023-02-02 | | | |
| 2023-02-02 | 2023-02-02 | 2023-02-02 | 2023-02-02 | | | |
| 2023-02-02 | 2023-02-02 | 2023-02-02 | 2023-02-02 | | | |
| 2023-02-02 | 2023-02-02 | 2023-02-02 | 2023-02-02 | | | |
| 2023-02-02 | 2023-02-02 | 2023-02-02 | 2023-02-02 | | | |
| - - | - - | - - | - - | | | |
| - - | - - | - - | - - | | | |
To avoid having conversion error " - - " not a valid date
I read all the input as string first (with input tool), and would like to remove all data with " - - " before I changed back to date as datatype
I get data like "20230131" in string with 8 as size
Since the DateTime tool only works on one column, I would like to use formula tool instead ( to avoid having 2-30 datetime tool in canvas)
I tried formula "DateTimeParse([TMP_RT_DT],'%Y%m%d')" the error of data will be truncated to "2023-01-" due to the size limit of 8.
and by using this, I only get string data that looks like date.
Would like to ask how can i get rid of those " - - " (with no conversion error) and get a date (date as data type) as my output.
