Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
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.
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.
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 !!
I've not got a Qualify * ; statement so logically there's no reason why I cannot get rid of this then. Thanx.
qualify is renames the field.
tablename.fieldname.
Unqualify can reverses the effect of qualify.
Thanks