Filter datable with column value based on few conditions

Help Activities
,
1

I have to filter datatable dt1 which has Column name as ‘name’ ex :compass accident employee
I have to filter products which has name containing accident as coverage and employee as claimant

2

@sheetal_Bora

Welcome to our UiPath community.

Try below select Query to filter DataTable.

    outputDT = dt1.Select("accident = 'coverage' AND employee = 'claimant'").CopyToDataTable
4

Hi @sheetal_Bora

Can you be more brief on the above?

Regards

5

From above datable obtain the value from column -name which has or contains accident and employee these two words based on inputs

6

Hi @sheetal_Bora,

I couldn’t understand your query properly but based upon how much I understood I hope the below code will give you the required output

var_DataTable.Select.Where(function(dr) dr(“Name”).ToString.ToLower.Contains(“accident”) And dr(“Name”).ToString.ToLower.Contains(“employee”)).CopyToDataTable

7

image
image1920×1440 674 KB

How to declare n fix this error

8

Thanks this worked for me @Mohsin_Inamdar

9

Great …!

If its worked for you please mark it as a solution

10

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