qualified and unqualied

[#1]

Can i used the qualify and unqualify when i extract data from database instead of files..

[bumin · Accepted solution]

yes you can use it for the dadabase too

[rubenmarin]

"qualify" renames the fields adding a prefix with the QlikView table name, it doesn't matter the source you are using to load the table, it can be be database, files, inline, resident...

[engishfaque]

Dear Hammad,

Yes, you can. Kindly find attached document for better understanding.

However, you can use "Rename" or "AS" clause for renaming the fields.

Kind regards,

Ishfaque Ahmed

[#5]

can be very usefull in order to avoid synthetic key's and to make a field key beginning with prefix

FE

Qualify '*';

unqualify '#';

Table:

load Keyfield as #Key,

       *

from InputTable;

HTH

F.