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