topic Re: Table Not Found in QlikView

Table Not Found

Tue, 06 Oct 2015 09:08:41 GMT

Thanks

Madhu

Re: Table Not Found

MK_QSL — Tue, 06 Oct 2015 09:13:51 GMT

Table1:

Load * Inline

[

A, B

1, aa

2, bb

3, cc

];

NoConcatenate

Table2:

Load * Inline

[

A, B

4, xx

5, yy

6, zz

];

TAB:

Load *, RecNo(), RowNo() Resident Table2 Where A<>4;

Load *, RecNo(), RowNo() Resident Table1 Where A<>2;

Drop Table Table1;

Drop Table Table2;

Re: Table Not Found

PrashantSangle — Tue, 06 Oct 2015 09:13:55 GMT

Hi,

table1 and table2 have same dimension therefore it will auto conacatenated

if you dont want to auto conacatenated then write

NoConcatenate

after Table1 load

Regards

Re: Table Not Found

qlikviewwizard — Tue, 06 Oct 2015 09:13:57 GMT

Hi Use the script like this:

Table1:

your data

NoConcatenate

Table2:

your data

AB:

Your script

Re: Table Not Found

sujeetsingh — Tue, 06 Oct 2015 09:25:42 GMT

Use NoConcatenate

Re: Table Not Found

SreeniJD — Tue, 06 Oct 2015 09:48:41 GMT

Hi Josna,

Going back to basics of QV, when you have two tables with same number of columns(in fact same names)... QV engine auto concatenate the two tables... to avoid this, use "NoConcatenate" so that you can have two tables existed and then you can perform any resident load on these tables.

Happy to Help

Sreeni

Re: Table Not Found

qlikviewwizard — Tue, 06 Oct 2015 10:40:09 GMT

Hi Madhu, Did you able to resolve the issue?

Re: Table Not Found

Tue, 06 Oct 2015 10:43:03 GMT

Yes Arjun

Thnq

MAdhu

Re: Table Not Found

qlikviewwizard — Tue, 06 Oct 2015 10:46:25 GMT

Hi Madhu,

Please close the thread by selecting Correct Answer and helpful for someone to know the answer.