Hello,
Can anyone please guide me for the following scenario:
This is my input data (Screenshot)
What needs to be done:
- Add a new column "Date+No" (Here, I want Date and No. to be concatenated in one column)
- Add new column where Amt-Concat Column is also concatenated
-Groupby IDno
Expected Output:
Date | No | Amt | IDno | Date+No | Amt-Concat |
03172023 | 1 | 38 | 222 | 031720232, 031720233, 031820234 | 10,10,8 |
Expected row should only have one row after groupby four rows in the result
Please let me know if you have any questions.
Thank you in advance.
Solved! Go to Solution.
Hello,
Thank you so much for a quick response. How do I get the Date and No column as well that displays the first row
@nirvapatel1998 @There are two dates for the same id number, which date you want to be in the output?