This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Alteryx Gallery is experiencing a problem in which system emails are not being sent out. As a result, if you are attempting to sign up for a new account, you may be unable to verify your email address. We are working to solve this as soon as possible and will remove this notice once resolved.
- Add in a record ID tool - this will add a unique row ID to each row, starting with 1
- Then add a multi-field formula as @JordanB mentioned but with an if statement
this will fix the dates on the header row.
NOTE: if you want to use the header row (row 1), to rename the columns - this can be done with a dynamic rename - happy to mock this up if you need, just send over some sample data from your workflows (the data you have in the question above).