Marge cells in DT

Help
1

Hello Friends!
I have DT in this format:

DT
DT1152×648 16.7 KB

If country, city and name match up, I need to plus the price and get DT in this format:
dt1
dt11152×648 3.81 KB

Please give me advice how to do it.
Thanks

2

@Olek1 Can you send the xaml file where you have used that Build Datatable?

4

Hello Bro. It is simple xaml.file…I just want to understand how to do it…what activity I need to use to marge rows…

5

@Olek1 Yes, I know it’s a Simple xaml file, but it would be easier for me to bring up a Solution for that if you provide the xaml :sweat_smile:

6

@Olek1 The Operation that you want to do is Group By and Sum the The Same Group Values, there is Balareva Activity for that Purpose, or we can use a Linq expression to do it.

7

Sequence.xaml (6.7 KB)
Then I want to use Write Range activity to write data in this format:

dt1
dt11152×648 3.81 KB

8

@Olek1 Check this Workflow :
Output.zip (6.7 KB)

1 Like
9

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.