topic Re: Script for second sheet having data but data is not in sheet1 in QlikView

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

Tue, 01 Apr 2014 07:23:44 GMT

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 — Tue, 01 Apr 2014 07:28:40 GMT

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 — Tue, 01 Apr 2014 07:31:21 GMT

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 — Tue, 01 Apr 2014 07:39:42 GMT

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);