Error with Filter DataTable

Help
, ,
1

Hey Everyone I am facing error when filtering a Datatable. I am Filtering a datatable (Sheet2) Based on the contents of Sheet1. After using a filter data table I use output database to see the content of the filter data table activity.

The output contains only the Header line and not the rows which I expect as the output.

Please help .

@Palaniyappan

2

May I know what was was filtered if possible the screenshot of filter wizard
And did we try with select method
Cheers @Aditya_Bhalerao

3

FilterWizard
FilterWizard1917×992 81.4 KB
Image 2
Image 21491×791 49.3 KB

4

@Palaniyappan

What is the Select Method

5

Datatable.Select(your condition)

Cheers @Aditya_Bhalerao

6

@Palaniyappan
Did you take a look at the workflow ?

7

I did see any xaml here in this post buddy

8

@Palaniyappan Please take a look at the File, I named the files by your name :sweat_smile:

Palaniyappan.xaml (10.7 KB) Palaniyappan.xlsx (99.0 KB)

9

I have used the same bot for two different files and the results are like this.

Outputtable1
Outputtable11422×599 311 KB

Here is the Output from Output Data Table, it shows all the row that are filtered

Outputtable2.PNG
Outputtable2.PNG1644×866 246 KB

Here is another Output from Output Data Table, it doesnt take row values in the filtering action.

10

@Palaniyappan Take a look at the images

11

My name :expressionless:
Hehe
Fine let me check them once
Cheers @Aditya_Bhalerao

12

@Palaniyappan Any Updates

13

Hey @Aditya_Bhalerao

In the filter data table, the values you provide, are they matching with the values you have in those two columns? Just make sure whether those are a exact match…