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

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:

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.

Custom Tools

Accepted answers

@nirvapatel1998 One way of doing this with the summarise tool

@nirvapatel1998 One way of doing this with the summarise tool

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?

@nirvapatel1998 I used the first option for the field date