Sorting Data Table after filtering and AutoSum

[Tanzill_Ahsan]

I am using the filter data table to filter out required data then I am writing those into a separate sheet. If I want to write sorted data instead of a normal write what should I do?

I want to sum the INT values too at the bottom of the INT value column.

[Yurii_Horobets]

@Tanzill_Ahsan

write sorted data

Hi.
You can use this statement for integer column
dt = dt.AsEnumerable.OrderBy(Function (row) CInt(row("YourColumnName"))).CopyToDataTable

[Tanzill_Ahsan]

thank you but it would be helpful for me if you tell me a bit more detail about where in which sequence I should use this command

[Yurii_Horobets]

Have a look on Sort Data Table activity. It has userfriendly interface and can help you.

[Yurii_Horobets]

@Tanzill_Ahsan

where in which sequence

Write that in Assign activity (see screenshot)

[Tanzill_Ahsan]

this is the error message I am getting while tryna assign this command in assign act.

[Yurii_Horobets]

@Tanzill_Ahsan

sum the INT values

Create a new variable, use Assign activity, then Add Data Row

sum = dt.AsEnumerable.Sum(Function (row) CInt(row(“Name”)))

[Yurii_Horobets]

[Tanzill_Ahsan]

maybe I am missing something

[Yurii_Horobets]

[Tanzill_Ahsan]

using the same command with this design. Maybe there are some internal errors. Thanks again for your help

[Yurii_Horobets]

You should NOT write equals sign in ‘Value’ section, because there is one between ‘To’ and ‘Value’