Sub Query syntax

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 from [Sheet2$])”

So that the result is

Eno EStatus

  1.  Active

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

Any suggestions please


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 :blush:

Mark as solution and like it if this helps you :slight_smile:

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

1 Like