Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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.
Then you will have to rename them.
Not happening I tried