Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
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