I want to filter the Column value 10%

Help Activities
, ,
1

Hi, I want to Filter the Datatable “DT_SKU” in which Column “PRIGCP%” contains “10%”
I used the Filter data table but it didn’t get can anyone share the VBcode/Linq query for this scenario?

2

@Melbin_Antu

Can you provide more data about your requirement

3

what was done, what is failing

(From d in DT_SKU.AsEnumerable
Let cv = d("PRIGCP%").toString
Where cv.Contains("10%")
Select r =d).CopyToDataTable

Handling empty results:
:ambulance: :sos: [FirstAid] Handling of The source contains no DataRows exception - News / Tutorials - UiPath Community Forum

4

Hi @Melbin_Antu,

For this you can use Linq query,

DT_SKU.AsEnumerable.Where(Function(x) x(“PRIGCP%”).ToString.Trim.Contains(“10%”)).CopyToDataTable.

5

Hi @Melbin_Antu

Try the below linq query:

dtFiltered = DT_SKU.AsEnumerable().Where(Function(row) row.Field(Of String)("PRIGCP%").Contains("10%")).CopyToDataTable()

Regards