Concatenate rows


#1

Hi Experts,

I have rows in table and it contains cust_id values duplicate but customer names is different .below is the given input.

Customer_id Customer_Name
111 A
111 B
112 C

Expecting Output:

Customer_id Customer_Name
111 A,B
112 C
Thanks in advance

Regards
Ramesh


#2

Hi @ramesh988,

Input
Customer_id Customer_Name
111 A
111 B
112 C

  • Using Read Range activity to Read the Data to Datatable.
  • Get the Distinct value Customer_id from DataTable
  • based on the Customer_id get the all the Customer_Name to array and join into string value and append the value to output datatable.
  • using write range write the data to excel sheet.

Final Output
Customer_id Customer_Name
111 A,B
112 C

Please refer below xaml file for how to Concatenate rows.

excela.xlsx (11.7 KB)
Concatenaterows.xaml (14.6 KB)

Regards,
Arivu


#3

Thanks a lot Arivu.