topic Re: Can we use more than one Resident Table? in QlikView

Can we use more than one Resident Table?

Saravanan_Desingh — Tue, 24 Nov 2015 17:33:04 GMT

I just started learning QV. I have a situation. My Table looks like this.

RawData:

Load r1, r2, r3 from data.xls;

Tab1;

Load r2 as t21, r3 as t31 Resident RawData where r1='A';

Tab2;

Load r2 as t22, r3 as t32 Resident RawData where r1='B';

While I try the above, I am getting Field not found Error for Tab2.

If the above steps are not possible, can you help me with any other smart approach? Thanks.

Re: Can we use more than one Resident Table?

sunny_talwar — Tue, 24 Nov 2015 17:45:21 GMT

Are you using semi-colon ( ; ) after the table name?

Are you sure you are not dropping RawData after creating Tab1?

Re: Can we use more than one Resident Table?

Saravanan_Desingh — Tue, 24 Nov 2015 17:49:24 GMT

I am sorry. Its typo. I was converting my live data to understandable format. Please see my script.

RawData:

Load r1, r2, r3 from data.xls;

Tab1:

Load r2 as t21, r3 as t31 Resident RawData where r1='A';

Tab2:

Load r2 as t22, r3 as t32 Resident RawData where r1='B';

Tab3:

Load r2 as t23, r3 as t33 Resident RawData where r1='C';

Drop Table RawData;

I want to split the table into 3, with different field names based on a condition.

Re: Can we use more than one Resident Table?

gsbeaton — Tue, 24 Nov 2015 17:56:27 GMT

I suspect the problem is your semi colon after the table names, it should be

Tab1:
Load r2 as t21, r3 as t31 Resident RawData where r1='A';

Tab2:
Load r2 as t22, r3 as t32 Resident RawData where r1='B';

Other than that, your syntax is correct and this is perfectly legitimate in QlikView.

Hope that helps

George

Re: Can we use more than one Resident Table?

sunny_talwar — Tue, 24 Nov 2015 17:59:55 GMT

Can you share a sample of where it isn't working? I don't see any reason why the above script should have a problem running?

Re: Can we use more than one Resident Table?

Tue, 24 Nov 2015 18:03:41 GMT

Yes we can use more than one resident table.... please share the qvw file.

Re: Can we use more than one Resident Table?

sunny_talwar — Tue, 24 Nov 2015 18:05:04 GMT

This is working for me:

RawData:

LOAD r1,

r2,

FROM

Data123.xlsx

(ooxml, embedded labels, table is Sheet1);

Tab1:

Load r2 as t21, r3 as t31 Resident RawData where r1='A';

Tab2:

Load r2 as t22, r3 as t32 Resident RawData where r1='B';

Tab3:

Load r2 as t23, r3 as t33 Resident RawData where r1='C';

DROP Table RawData;

Re: Can we use more than one Resident Table?

Saravanan_Desingh — Tue, 24 Nov 2015 20:43:06 GMT

Thank you all for your timely response.

My issue was sorted out. I did a mistake in my where Clause.

Resident RawData

Where [Aligned Sector] Like 'Voice%'

;

It should have been

Resident RawData

Where [Aligned Sector] Like 'Voice*'

;

Anyway this thread clears few of my doubts.