Adding new fields, concat existing field, and return one row by group by

[nirvapatel1998]

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. 

[binu_acs · Accepted solution]

@nirvapatel1998 One way of doing this with the summarise tool

[nirvapatel1998]

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 

[binu_acs]

@nirvapatel1998 @There are two dates for the same id number, which date you want to be in the output?

[binu_acs]

@nirvapatel1998 I used the first option for the field date