Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Two unlinked tables in one QVW file

I am hoping to be able to load two different Excel files in one QVW but not have them link. I need to data on each tab to be independent of each other. I know I can create two different QVW files, but was hoping to make a one stop shopping experience for my users. Is this possible?

Thanks

7 Replies
rustyfishbones
Not applicable

Re: Two unlinked tables in one QVW file

use

NOCONCATENATE

before the LOAD of the 2nd file

swuehl
Not applicable

Re: Two unlinked tables in one QVW file

Sure, you just need to make sure that both tables do not share any field name. You can use the QUALIFY statement to ensure this.

QUALIFY *;

TableA:

LOAD * FROM TableA.xls;

TableB:

LOAD * FROM TableB.xls;

Not applicable

Re: Two unlinked tables in one QVW file

That didn't work. The tables are still joined. The biggest is that the second tab adds data to the first tab which makes the first tab data incorrect.

Sent from my iPhone

Not applicable

Re: Two unlinked tables in one QVW file

Unfortunately the two tables do have the same name. Though some renaming would fix that, but that's a lot of manual intervention.

Sent from my iPhone

swuehl
Not applicable

Re: Two unlinked tables in one QVW file

Your tables have the same name in the QV data model? Why that?

Or do you mean, they use the same source table? (Hm, so why load it twice then?)

But even if so, qualify should create the data islands I assume you want:

INPUT:

LOAD * INLINE [

A,B

10,20

];

QUALIFY * ;

TableA:

LOAD * RESIDENT INPUT;

TableB:

LOAD * RESIDENT INPUT;

paulyeo11
Not applicable

Re: Two unlinked tables in one QVW file

can you pls share your data model.

Not applicable

Re: Two unlinked tables in one QVW file

You can create a column in table two for not concatenate the tables

Exemple

TableA:

LOAD

     *

FROM TableA.xls;

TableB:

LOAD

     *,

' ' as ColummTeste

FROM TableB.xls;