Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Community is experiencing an influx of spam. As we work toward a solution, please use the 'Notify Moderator' option on the ellipsis menu to flag inappropriate posts.
Alteryx Designer Desktop Discussions
Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED
Hi All,
I have data as shown in the screenshot below. Now my Requirement is to segregate the End Date2 column data into two different columns. Is that possible. Please see the screenshot for the required output. Note: Not all employee Ids will be having 2 End dates
INPUT data
Required Output
| EMPCODE | DOJ | DOL | End Date1 | End Date2 |
| 100716032 | 6/15/2016 | 9/19/2021 | [Null] | [Null] |
| 105988449 | 12/18/2019 | 9/19/2021 | 9/17/2021 | 10/17/2021 |
| 106026773 | 1/6/2020 | 9/19/2021 | 9/5/2021 | 10/5/2021 |
| 106143203 | 2/17/2020 | 9/19/2021 | 9/16/2021 | 10/16/2021 |
| 106147970 | 5/25/2020 | 9/19/2021 | 9/24/2021 | [Null] |
Thanks in advance!
Solved! Go to Solution.
