What does unqualify *; do?

[shane_spencer]

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?

[Anonymous · Accepted solution]

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.

[Siva_Sankar]

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.

[#4]

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 !!

[shane_spencer]

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

[deepakqlikview_123]

qualify is renames the field.

tablename.fieldname.

Unqualify can reverses the effect of qualify.

Thanks