Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Convert after row 5 and everything after to date format for chosen multiple fields

wonka1234
10 - Fireball

Hi I need help to convert after row 5 and everything after to date format for chosen multiple fields

 

ie 

 

F40F41
4041
nullnull
nullnull
Revised DateStart Date
3-Nov-2330-Oct-23
17-Apr-23########
17-Apr-23########
17-Apr-23########
17-Apr-23########
17-Apr-23########

 

to the dates being yyyy-mm-dd format.. and leave the headers the same.. not sure if that is possible.

 

 

1 REPLY 1
binuacs
21 - Polaris

@wonka1234 Alteryx doesn't support multiple data types in a single column, I mean the same column cannot have DATE data type and STRING date type like excel. If you want to keep only the String type here is the one way of doing this

binuacs_0-1684250921598.png

 

Labels