topic Re: What does unqualify *; do? in QlikView

What does unqualify *; do?

shane_spencer — Fri, 05 Sep 2014 09:09:56 GMT

I've got a script that I inherited with the line

unqualify *;

I'm not sure what it does or if I need it. Can someone please advise?

Re: What does unqualify *; do?

Anonymous — Fri, 05 Sep 2014 09:12:11 GMT

Earlier in the script I expect you will find :

Qualify * ;

This means that any load statement after will prefix the field names with the table names and a dot.

The UnQualify * turns this off so things are back to default.

Re: What does unqualify *; do?

Siva_Sankar — Fri, 05 Sep 2014 09:13:17 GMT

Qualify statements renames all the fields with the table name prefix which are mentioned in the statement. QUALIFY *; it can be used above the table name. * is to rename all the field name in the table.

Otherwise u can also specify each field that u wanted to rename.

UNQUALIFY is reverse process of QUALIFY statement.

If u r not using the UNQUALIFY statement after using QUALIFY, it ll rename all fields of all the table below the QUALIFY.

QUALIFY *; //or QUALIFY OrderID, CustomerName;

Orders: //Table Name

LOAD OrderID,

OrderName,

CustomerName,

FROM xxx.xls;

UNQUALIFY *;

If u use * then, ur fields ll be like this: Orders.OrderID

Orders.OrderName

Orders.CustomerName

If not using *, it ll rename oly the fields u have mentioned.

Re: What does unqualify *; do?

Fri, 05 Sep 2014 09:15:42 GMT

Hi Shane ,

The unqualify statement is used for switching off the qualification of field names that has been previously switched on by the qualify statement.

FOR eg

Qualify*

Table 1:

Load A from Excel1;

Qualify *;

O/p field name will be followed by table name (Table1.A ) .

NOte : if u will not mention unqualify * at the end of the particular table ,then qualify statement will be effective for the all the other table after that one.

THanks !!

Re: What does unqualify *; do?

shane_spencer — Fri, 05 Sep 2014 09:16:27 GMT

I've not got a Qualify * ; statement so logically there's no reason why I cannot get rid of this then. Thanx.

Re: What does unqualify *; do?

deepakqlikview_123 — Fri, 05 Sep 2014 09:19:18 GMT

qualify is renames the field.

tablename.fieldname.

Unqualify can reverses the effect of qualify.

Thanks