topic Re: Fieldnames changing after store and load in QlikView

Fieldnames changing after store and load

christian_frees — Sat, 16 Nov 2024 21:40:03 GMT

Hello,

i want to store and later load data to qvd files.

After the first load of the data from the sql database the fieldname look like table.fieldname.

Like this:

tblAdress.Name1

tblAdress.Street

Now i stored the data to qvd.files:

store tblAdress to tblAdress.qvd (qvd);

In the following documents i try to load the data again:

load * from tblAdress.qvd (qvd);

the data is loaded but the fieldnames changed to

tblAdress.tblAdress.Name1

tblAdress.tblAdress.Street

How can i solved these issue?

Greetings

Christian

Remark: Qualify is *;

Gysbert_Wassenaar — Thu, 03 Jan 2019 10:00:27 GMT

Remove the Qualify *;
That's why the table name is added as a prefix to the fields.

christian_frees — Thu, 03 Jan 2019 10:06:50 GMT

Hello,

i need the qualify statement for lots of fields and don't want to change that.

so now i changed the following things.

1. I put all the unqualify statements to a subroutine.

2. The load statement is now changed to :

unqualify *;

load * from tblAdress.qvd (qvd);

call SetQualify;

Now it works. Thanks for you support.