I am a beginner in uipath.I am having an exel group and sum

Capture

output
Capture1

Can any one help with .xaml file

Hi @Sreedas_Sreedharan,

I have created the Xaml file as per your requirement.

Thanks,
ShobhitFilterDataTable.zip (8.2 KB)

@shobhit286 Thank you.If I am having another column how its solved

Capture1

Output

Capture2

Hi @Sreedas_Sreedharan

  • Add another column in Build data table i.e “Amount1”
    -Use another assign activity inside for each data row
    value1 = Int32.Parse((item(“Amount1”).tostring))+Value1
    -Add another assign activity before Add data row
    newDataRow(“Amount1”) = value1

In this way you can add multiple column

Thanks,
Shobhit

1 Like

Hi @Sreedas_Sreedharan,

Attached Xaml
FilterDataTable.xaml (12.8 KB)

Thanks,
Shobhit

1 Like

Thanks Shobhit
How is it possible to put in loop for eg: Amount1,Amount2,Amount4…Amount30
and the values in values1,values2,values3,…values30

@Sreedas_Sreedharan,

I have developed dynamic code
Now you don’t have to worry about no of columns and name of columns except first column which you are going to filter

FilterDataTable.xaml (16.3 KB)

1 Like

Thanks a lot Shobhit

Its working fine

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