Field, Table prefix.

[#1]

This is probably the only/clear to last thing I don't understand about QlikView.

I have 173 tables in my database, full of fields.

Here's my question.

I pull in let's say 25-50 fields from one of these 173 tables.

A lot of these tables have similar fields, so if I'm pulling from 3 or more tables, it can get really confusing what's what.

This is causing major issues when I try and create QVD's.

How can I join the table name, with the field.

AddCutsLogs.UserTag8Code

Opposed to

UserTag8Code

or

Jobs.UserTag8Code

Opposed to

UserTag8Code.

Thanks again...

"If you can't explain it simply, you don't understand itwell enough." Albert Einstein 1921

[#2 · Accepted solution]

Hello, sorry for my bad english. With the statement QUALIFY and UNQULIFY.

In the script before you load data from tables put the QUALIFY statement. Example:

QUALIFY *;

Sales:

LOAD

         ID,

         Price,

         Amount

Resident Sales_aux;

UNQUALIFY *;

With this we add the table name as a prefix to the field name:

Sales.ID,

Sales.Price,

Sales.Amount

Regards.

Luciano Muñoz

[#3]

Sir you are a gentleman and a scholar. Thank you very very much.

[#4]

I've got another question, why do you need to unqualify, after you have qualified? Is there any particular reason?

Thanks!

EDIT: Also, what is the _aux on Resident Sales_aux?

[#5]

Thanks, because maybe you not need to use the table name as a prefix in all tables, the UNQUALIFY abort the QUALIFY statement.

Don't worry about the _aux jej, is a suffix used to indicate it is an auxiliary table will be deleted after.

I hope this helps.