I have rows in table and it contains cust_id values duplicate but customer names is different .below is the given input.
Thanks in advance
- 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.
Please refer below xaml file for how to Concatenate rows.
excela.xlsx (11.7 KB)
Concatenaterows.xaml (14.6 KB)
I am getting error while performing the same operation-
Cannot interpret token ‘=’ at position 9.
Say if you have multiple rows and columns?