Comparing the value

[Jijendiran_Murugan (Jije)]

this one is sample input
i need to filter value from its 4 to 7 in a and b column
sample output

[vrdabberu (Varunraj Dabberu)]

Hi @Jijendiran_Murugan

you can use the filter data table activity and give the consitions as below:

Input:

output:

Regards

[vrdabberu (Varunraj Dabberu)]

Hi @Jijendiran_Murugan

Hope you got the solution for your query. If yes, please mark it as solution or else happy to help.

Regards

[vrdabberu (Varunraj Dabberu)]

Hi @Jijendiran_Murugan

If you require a linq query please check the below:

use assign activity

dt = dt.AsEnumerable().Where(Function(row) (CInt(row("a")) > 4 AndAlso CInt(row("a")) < 7) OrElse (CInt(row("b")) > 4 AndAlso CInt(row("b")) < 7)).CopyToDataTable()

Regards

[vrdabberu (Varunraj Dabberu)]

I Hope you got the solution for your query. If yes, please mark it as solution to clsoe the topic orelse I’m happy to help @Jijendiran_Murugan

Happy Automation!!

[RajKumar_DC (RajKumar Durai)]

Hi @Jijendiran_Murugan ,

Check this

Input Dt:

[Col1,Col2,Col3
0,2,jyu
2,5,sdfs
5,6,asdasd
6,8,xbe
8,10,thrt
]

Output Dt:

[Col1,Col2,Col3
2,5,sdfs
5,6,asdasd
]

Code:

dt.AsEnumerable.Where(Function(x) CInt(x("Col2").ToString)>=4 AndAlso CInt(x("Col2").ToString)<=7).CopyToDataTable

Workflow

Thanks,