Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
christian_frees
Partner - Contributor II
Partner - Contributor II

Fieldnames changing after store and load

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

Labels (1)
1 Solution

Accepted Solutions
christian_frees
Partner - Contributor II
Partner - Contributor II
Author

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.

View solution in original post

2 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

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

talk is cheap, supply exceeds demand
christian_frees
Partner - Contributor II
Partner - Contributor II
Author

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.