How to split data table?

Help
, ,
1

I have a data table like this

image

I want to sort this table (I have done this using sort dt activity)

I want to group 1.1 together and 1.2 together and give 2 data tables

I tried using filter but it wont be dynamic so pls help

2

@Palaniyappan

3

@lakshman sir can u take a look at this too

4

@cybzom

Use Read Range activity to read the data from Excel file and will give you output as DataTable and say ‘inputDT’ and then try below expressions.

DT1 = (From p In inputDT.Select Where (p("ColumnName").Tostring.Contains("1.1") Select p).CopyToDataTable


DT2 = (From p In inputDT.Select Where (p("ColumnName").Tostring.Contains("1.2") Select p).CopyToDataTable
2 Likes
5

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