Sub Query syntax

[MLT]

Hi I’m trying to compare two excel files like

I have one excel file with two sheets (Sheet1 and Sheet2) and I made successful connection

I want to filter the data from Sheet1 which is not available in Sheet2.

Sheet 1 :
Eno EStatus

1.         Active
   

2.         Inactive
   

3.         Active
   

Sheet 2:

Eno EStatus

1.          Active
   

2.        Inactive
   

I written a query :
“Select * from [Sheet1$] where EStatus=‘Active’ and Eno not in (select E.no from [Sheet2$])”

So that the result is

Eno EStatus

3.  Active
   

But I’m getting error like Execute Query: In operator without using()

Any suggestions please

[Pratik_Wavhal]

Hi @MLT

Instead of using Query on Excel data you can use Join Datatable Activity by applying Left Join :-

By doing this might give you expected Output

Mark as solution and like it if this helps you

Happy Automation

Best Regards
Er Pratik Wavhal