Script for second sheet having data but data is not in sheet1

[#1]

Hi All,

I have 2 excel sheets which is having month and Account no. I want to find Accounts which are used in sheet 2 but not in sheet1.

So how to write script for that.Administrator

[its_anandrjs]

Load your table like

Tab1:

Load

month1,

Account1 as Account_no

From Sheet1 Location;

right join

Tab2:

Load

month2,

Account2 as Account_no

From Sheet2 Location;

By this you get only second accounts in new table

Hope this helps

[alexandros17]

tab1:

load month, account as a1 from sheet1 (this is not the right syntax obviously)

tab2:

noconcatenate

load month, account from sheet2

where not exists(a1, account)

[brijesh1991]

Tab1:

Load

month1,

Account1

From Sheet1;

Tab2:

Load

month2,

Account2

From Sheet2 not exist(Account1,Account2);

drop table Tab1;

store Tab2 into [../Data/onlysheet2.qvd](qvd);