I want to filter rows of a data table which are having same column values, example same Column1 and Column5 values

Help Studio
, ,
1

I want to filter rows of a data table which are having same column values, example same Column1 and Column5 values,
Can anyone suggest the linq for this ?

2

Hi @Ramakanth_Gattupalli1

Can you share sample input and expected output

Regards

3

myDT.Select("[Column2] = [Column5]").CopyToDataTable

4

image
image1072×281 13.3 KB

Input is a data table with many rows.
Output is, the selected rows which are having same values of Broker office column and User Name column .
And one more thing in Broker office column, rk and rk pvt are same, Etrade and Etrade Pvt are same.

5

Hi @Ramakanth_Gattupalli1

Check the below workflow:

image
image899×580 35.4 KB

Sequence58.xaml (10.2 KB)
data (2).xlsx (9.8 KB)

Output:

image
image917×232 6.72 KB

Hope it helps!!

6

myDT.Select("[Broker Office] = [Broker] OR ([Broker Office] = 'ETrade pvt' AND [Broker] = ' ETrade') OR ([Broker Office] = 'ETrade' AND [Broker] = 'ETrade pvt')").CopyToDataTable