topic Field, Table prefix. in QlikView

Field, Table prefix.

Wed, 29 Feb 2012 18:01:16 GMT

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

Jobs.UserTag8Code

Opposed to

UserTag8Code.

Thanks again...

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

Wed, 29 Feb 2012 18:36:21 GMT

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

Wed, 29 Feb 2012 19:31:50 GMT

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

Wed, 29 Feb 2012 19:36:54 GMT

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?

Wed, 29 Feb 2012 19:50:36 GMT

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.