Facing problem with Filter Datatable Activity in uipath

Help Studio
1

Hi All,
Below is SampleDT
image
I want to filter all the data where value in Code1 != value in code 2 as OutputDT
image
I tried using filter DT activity and LinQ but unable to filter and getting all the rows in output.
I am using Uipath Studio 2018.4.3
Please help.

2

@Anamika15
give a try on

(From d in YourDataTableVar.AsEnumerable
Where Not d("Code1").toString.Trim.Equals(d("Code2").toString.Trim)
Select d).CopyToDataTable

In case of empty filter results are to expect apply following pattern

grafik
grafik707×346 46.6 KB

3

I have already tried this linq. Its not doing any filter opernation on the datatable.

4

@Anamika15
can you please do following
set a breakpoint within the flow after data was read in
debug to the Breakpoint
share the datatable content with us (locals panels, expand with click on pencil/magnifier) make screenshot from it

Thanks

5

Hi @Anamika15

Please look at this method and let me know the result

Step 1 : Assign ResDT->(From ax in InputDT.AsEnumerable select ax.Item(“Code2”)).ToArray
Step 2 : Assign FinalDT->(From roww in InputDT where Not ResDT.Contains(roww.Item(“Code1”)) Select roww).CopyToDatatable()

Here ResDT is of type Object Array (Object) and FinalDT is of type DataTabe

Regards,
@poorna_nayak07

6

Hi @Anamika15 Try this way

  1. Read the excel file and store in dt1 variable

  2. use the following linq query to get the required result

    Dt3 = dt1.AsEnumerable().Where(Function(row) row(“Code1”).ToString<>row(“Code2”).ToString).CopyToDataTable

  3. Write the resultant Dt3 to an excel file

I tried the code with two sample excel sheets as like below
image

Result i got is image (via output datatable activity i output the datatable in string format to demonstrate the result)

Workflow
excel.zip (39.0 KB)

Hope it helps you

Regards

Nived N
Happy Automation

7

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