Merge rows based on condition

[gokulvasant]

Hi Guys,
Please check the below scenario, I would like to know it’s possible to do:
Input:

Output:

If name matches mean we need to merge the other two columns based on values.

Thank you.

[srdjan.suc]

Can you send the XAML file with the Data Tables, i would try to do this in Merge Data Table activity

[gokulvasant]

Sample Input Sheet.xlsx (10.3 KB)

@srdjan.suc Please check the sample sheet

[Manjuts90]

@gokulvasant Please check below xaml file.

Test.xaml (18.4 KB)

[gokulvasant]

@Manjuts90 thank you it’s working like a charm,

I have one more query, I want to compare both column name and service_from column …

then data’s want to merge.

Just guide me on the same.

[Manjuts90]

@gokulvasant Can you tell me with what you have to compare both Columns “Name” and “Service_From”?

[gokulvasant]

Yes Dude,
name is string and service from is date data type

[Manjuts90]

@gokulvasant Can you give some example for doing comparison?

[gokulvasant]

Input.xlsx (230.4 KB)

Hi please check this input sheet, I want to compare first columns and need to do action on the 3rd and 4th column… remaining columns as it is.

[gokulvasant]

@Manjuts90
Hai any updates on that… thank you.

[Manjuts90]

@gokulvasant Sorry for the delay please find attached file below.

Test.xaml (23.2 KB)

Please find output in sheet4, i have changed 1st first Column name in the input file.

Input.xlsx (209.3 KB)

you may need to change the column Name in workflow or excel depending on you requirement.

This is not optimal solution for your problem u can use it for time being.

[gokulvasant]

Yes @Manjuts90, it’s working… but I didn’t get the total amount…

[Manjuts90]

@gokulvasant Check below file and let me know know if total amount is missing or not.

Test.xaml (23.2 KB)

[gokulvasant]

@Manjuts90 thanks a lott…

[Manjuts90]

@gokulvasant Ur welcome