Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
I am trying to achieve the below join in the qlikview data model.
When I join the new table GP , It became with table name prefix -
Please kindly assist me in the qlikview script.
Here is the script below :
ED_AP_PAT_TMP:
NoConcatenate
LOAD DISTINCT
[Person Area Uid],_VisitKey, [Facility Identifier], 'Yes' as [Exclude Discharged Stay]
Resident ED;
Concatenate (ED_AP_PAT_TMP)
LOAD
[Person Area Uid],_VisitKey, [Facility Identifier], if([AP._discharge_flag] = 1, NULL(), 'Yes') as [Exclude Discharged Stay]
Resident AP;
ED_AP_PAT:
NoConcatenate
LOAD DISTINCT *
RESIDENT ED_AP_PAT_TMP;
DROP TABLE ED_AP_PAT_TMP;
ED_AP_PAT_TMP1:
Concatenate (ED_AP_PAT)
LOAD
[Person Area Uid],_VisitKey, [Facility Identifier], 'Yes' as [Exclude Discharged Stay]
Resident GP;
DROP FIELD [Person Area Uid],[Facility Identifier] FROM ED;
DROP FIELD [Person Area Uid],[Facility Identifier] FROM AP;
DROP FIELD [Person Area Uid],[Facility Identifier] FROM GP;
regards
But if you did Qualify *; somewhere earlier in your script, it will apply until your Unqualify *;
Are you using Qualify in your script ?
No, I remove the Qualify .
and Put Unqualify * but not working
can you show more of your script to let us see what's happening
ED_AP_PAT_TMP:
NoConcatenate
LOAD DISTINCT
[Person Area Uid],_VisitKey, [Facility Identifier], 'Yes' as [Exclude Discharged Stay]
Resident ED;
Concatenate (ED_AP_PAT_TMP)
LOAD
[Person Area Uid],_VisitKey, [Facility Identifier], if([AP._discharge_flag] = 1, NULL(), 'Yes') as [Exclude Discharged Stay]
Resident AP;
Concatenate (ED_AP_PAT_TMP)
LOAD
[Person Area Uid],_VisitKey, [Facility Identifier], 'Y' as [Exclude Discharged Stay]
Resident GP;
UNQUALIFY *;
ED_AP_PAT:
NoConcatenate
LOAD DISTINCT *
RESIDENT ED_AP_PAT_TMP;
DROP TABLE ED_AP_PAT_TMP;
DROP FIELD [Person Area Uid],[Facility Identifier] FROM ED;
DROP FIELD [Person Area Uid],[Facility Identifier] FROM AP;
DROP FIELD [Person Area Uid],[Facility Identifier] FROM GP;
There must be a Qualify earlier in the script that is qualifying each [Exclude Discharged Stay]
Hi Lisa ,
the field [Exclude Discharged Stay] is created on this tab for the first time by this script , so I ne ver Qualify [Exclude Discharged Stay] before the script.
ED_AP_PAT_TMP:
NoConcatenate
LOAD DISTINCT
[Person Area Uid],_VisitKey, [Facility Identifier], 'Yes' as [Exclude Discharged Stay]
Resident ED;
Concatenate (ED_AP_PAT_TMP)
LOAD
[Person Area Uid],_VisitKey, [Facility Identifier], if([AP._discharge_flag] = 1, NULL(), 'Yes') as [Exclude Discharged Stay]
Resident AP;
Concatenate (ED_AP_PAT_TMP)
LOAD
[Person Area Uid],_VisitKey, [Facility Identifier], 'Y' as [Exclude Discharged Stay]
Resident GP;
But if you did Qualify *; somewhere earlier in your script, it will apply until your Unqualify *;