table name in combined load

[#1]

Hi

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

[sparur]

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);

[#3]

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)

[#4]

You need to unqualify before you load your budget.

[sparur]

hello, Juerg,

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

[sparur]

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);

[#7]

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