Distinct values from a datatable only getting applied on the last sheet

[Ishan_Shelke1 (Ishan Shelke)]

I am trying to get distinct values from my 1 excel which has 4 sheets in it.

But somehow only the 4th sheet gives the distinct values on the first three the logic doesn’t get applied.

As you can see in the above screenshot only the SQL sheet is giving the right output rest sheets are not.

Xaml File →
Main.xaml (44.7 KB)

Excel File →
test.xlsx (29.5 KB)

[jack.chan]

i think its because you used dtFiltered instead of dt so some of the rows were excluded

if i change dtFiltered to dt then its correct

[Ishan_Shelke1 (Ishan Shelke)]

I need to read my result from the dtfiltered only. because I have filtered out some rows from the main dt and stored them into the dtfiltered

[jack.chan]

ok this should be A2 instead of A3 then it will work, dont have to change dtFiltered