Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
please explain the qulify and unqualify
reddy
Hello!
Is ist possible to rename the unqualified OrderId? I tried it but it does not work!
QUALIFY *;
UNQUALIFY OrderID;
Orders:
LOAD OrderID AS TestOrderID, // this TestOrderID exists in another Table and should be a key
Order Name,
CustomerName,
FROM xxx.xls;
Thank you!
Is it possible to given another random name while using qualify??
Orders.OrderID
Orders.OrderName
Orders.CustomerName
for example -
In above result set the fields are getting renamed with prefix as "Orders" because the table name is Orders.
If we want to quality all the fields from orders table but with another random name such as Temp, so expected result should be as witout changing table name from Orders to Temp?
Temp.OrderID
Temp.OrderName
Temp.CustomerName
Check the below Linkedin post for better understanding.
Dear Amit,
What's new in your post, in fact I found it is incomplete information about Qualify and Unqualify.
Kindly read the question again.
Shared post is about how Qualify function work.
bydefault it's takes the name of table as prefix.