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.
Hi,
Good question, I believe data transform can address this requirement. Can I request the sample input data?
Regards,
Pratik
Thanks for your response @pdave87 . attaching the input sample
@hemant86 Transpose to create extra column and cross tab to parse the date into two - method of aggregation is "First" and "Last" both selected (not shown in screen-print), have a good day! 🙂
User | Count |
---|---|
18 | |
14 | |
13 | |
9 | |
8 |