topic table name in combined load in QlikView

table name in combined load

Tue, 02 Nov 2010 12:40:26 GMT

I am trying to combine current and budget numbers into the same table to avoid circular references.
The fields added by the second load however get another table prefix?

QUALIFY *;
UNQUALIFY "*CD";
Entries:
load
Account as Account_CD,
Value_Is
from $(DataPath) Is.qvd(qvd);

Load
Account as Account_CD,
Budget
from $(DataPath)Budget.qvd(qvd);

This results in fields:
- Account_CD
- Entries.Value_Is
- Budget.Budget (-> wanted this to be Entries.Budget)

How to get the same table prefix?

Juerg

table name in combined load

sparur — Tue, 02 Nov 2010 12:58:34 GMT

Hello, Juerg.

Like as:

Entries:
load
Account as Account_CD,
Value_Is
from $(DataPath) Is.qvd(qvd);

Inner Join

Load
Account as Account_CD,
Budget
from $(DataPath)Budget.qvd(qvd);

table name in combined load

Wed, 03 Nov 2010 07:52:16 GMT

Hi Anatoli

Adding the "INNER JOIN" does not change the behaviour.

I still get
Entries.Value_Is
and
Budget.Budget

(I am using 10.00.8715 PE)

table name in combined load

Wed, 03 Nov 2010 08:24:19 GMT

You need to unqualify before you load your budget.

table name in combined load

sparur — Wed, 03 Nov 2010 08:35:30 GMT

hello, Juerg,

Why do you use QUALIFY statement. You shouldn't it.

table name in combined load

sparur — Wed, 03 Nov 2010 08:41:33 GMT

but if you want to use qualify statement you should rename fields manually, like this:

QUALIFY *;
UNQUALIFY "*CD";
Entries:
load
Account as Account_CD,
Value_Is
from $(DataPath) Is.qvd(qvd);

UNQUALIFY *;

Inner Join

Load
Account as Account_CD,
Budget AS Entries.Budget
from $(DataPath)Budget.qvd(qvd);

table name in combined load

Wed, 03 Nov 2010 08:56:35 GMT

Thanks

I am used to qualify all my fields that are not key fields.

In this case I can live with unqualifying Value_Is and Budget.

Anatoly: your version gives me
- Entries.Value_Is
and
- Budget (which I initially wanted to be Entries.Budget)

Looks a bit strange to me that the loader is not using the table specifyer given but creates the suffix from the file name?

Thanks for your help

Juerg