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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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.