Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
pradnya_avrioc
Contributor III
Contributor III

Unable to apply Unqualify

Qualify *;

[EVENT_RESULTS]: //9000 SRC 150
LOAD
RowNo() as EVENT_RESULTS,
event_date,
event_id;
SELECT *
FROM "MW_DATALAKE"."PUBLIC"."EVENT_RESULTS"
WHERE "event_date" >= '01/01/2023' ;// AND "event_id" IN (SELECT DISTINCT "event_id" FROM [EVENT_DETAILS]);

Left Join (EVENT_RESULTS)

[EVENT_DETAILS]: //30 SRC records
LOAD event_id,
event_name;
SELECT *
FROM "MW_DATALAKE"."PUBLIC"."EVENT_DETAILS"
WHERE "event_name" LIKE '%src%';

FINAL_TABLE:
LOAD
EVENT_RESULTS.event_date,
EVENT_RESULTS.event_id,
EVENT_DETAILS.event_name
RESIDENT [EVENT_RESULTS]
WHERE EVENT_RESULTS.event_id = EVENT_DETAILS.event_id;

Unqualify event_date, event_id, event_name;

DROP TABLE [EVENT_RESULTS];

exit Script;

 

I'm not getting only field names but like in the attached scrrenshot.

Labels (3)
4 Replies
Lisa_P
Employee
Employee

Qualify and Unqualify act like a switch to turn on and off Qualification for fields loaded after the statement. So if you are not wanting to Qualify event_date, event_id, event_name, then you need to move that statement up earlier in the script.

pradnya_avrioc
Contributor III
Contributor III
Author

I want to use Qualify as my script is running because of it but I'm not able to Unqualify them and get back to normal to use it further.

Lisa_P
Employee
Employee

Then you will have to rename them.

pradnya_avrioc
Contributor III
Contributor III
Author

Not happening I tried