Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
use
NOCONCATENATE
before the LOAD of the 2nd 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;
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
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
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;
can you pls share your data model.
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;