Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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)
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);