Table Not Found

[#1]

Thanks

Madhu

[MK_QSL]

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;

[PrashantSangle]

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

[qlikviewwizard]

Hi Use the script like this:

Table1:

your data

NoConcatenate

Table2:

your data

AB:

Your script

[sujeetsingh]

Use NoConcatenate

[SreeniJD]

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

[qlikviewwizard]

Hi Madhu, Did you able to resolve the issue?

[#8]

Yes Arjun

Thnq

MAdhu

[qlikviewwizard]

Hi Madhu,

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