topic Re: Load Script Problem in QlikView

Load Script Problem

Mon, 03 Dec 2012 16:32:16 GMT

Hi guys

I have a big issue here... I have to load some excel sheets to my QVW doc. However, there's a problem! I have two main tables (almost with the same column names) one for 2011 and another to 2012 and then I have my aux tables to match the codes in the main tables. The problem is: when I try to load the script, the QV does connections between the two main tables and that is something I don't want. As an example:

Main tables: DB1 ; DB2

Aux table: A, B ,C

DB1

Cod_A, Cod_B, Cod_C, PriceX, TotalY

DB2

Cod_A, Cod_B, Cod_C, TotalZ

Aux Tales A, B, C would include the mapping of Cod_A, Cod_B and Cod_C.

What I need is to avoid that QV does references the Cod_A, Cod_B and Cod_C between DB1 and DB2. I want DB1 and DB2 independent from each other!

I hope you can understand the problem.

Thanks in advance.

Best regards,

TMF

Re: Load Script Problem

RedSky001 — Mon, 03 Dec 2012 16:39:34 GMT

Not sure I really understand but sounds like you could be describg when tables are concatanted automatically if they have the same coloum headings, you can avoid this using the NoConcatenate keyword.

If this dosn't help can you provide a more complelete sample of your scrpt.

NoConcatenate

load *

Resident x;

Mark

Re: Load Script Problem

Mon, 03 Dec 2012 16:44:22 GMT

No, they have almost the same headings but they are in different sheet in my xls. I have to load then separatetly, not concatenate then. However, as almost of the headings have the same name, the QV make connections between the two main tables... I want to avoid that. BD1 and BD2 has connections between aux tables but must not have connections between themselves...

Re: Load Script Problem

Gysbert_Wassenaar — Mon, 03 Dec 2012 16:48:02 GMT

You're almost certainly better off putting both source tables in one target table together with a field to determine where the record came from. Qlikview will work better if you do. If you feel you must have two separate tables, you'll have to rename fields in one of the two tables so qlikview can't associate the tables.

Re: Load Script Problem

RedSky001 — Mon, 03 Dec 2012 16:54:35 GMT

If you go down the route of seperating the tables another way to rename the field names is to use the quality keyword:

ie:

QUALIFY *;

UNQUALIFY KEY;

load * Inline [Col_A,, Col_B, KEY

1,2,A

];

NoConcatenate

load * Inline [Col_A, Col_B, KEY

1,2,A

];