Two unlinked tables in one QVW file

[#1]

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

[rustyfishbones]

use

NOCONCATENATE

before the LOAD of the 2nd file

[swuehl]

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;

[#4]

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

[#5]

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]

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]

can you pls share your data model.

[#8]

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;