SE_TMP: Load [Facility Identifier], "Derived National Service Event Record Id", "SE.Service Event Record ID", 1 as count_se 1 as count_oos FROM QVD;
SE: NoConcatenate LOAD DISTINCT "OOS.Derived National Service Event Record Id" as IDKey, [Facility Identifier], "SE.Service Event Record ID", 1 as count_se 0 as count_oos RESIDENT OOS WHERE NOT EXISTS ("Derived National Service Event Record Id","OOS.Derived National Service Event Record Id") ;
Concatenate(SE) LOAD "Derived National Service Event Record Id" as IDKey, "Facility Identifier" ,"SE.Service Event Record ID" ,count_se as SE.count_se ,count_moh_se as SE.count_moh_se RESIDENT SE_TMP;
DROP TABLE SE_TMP;
from the middle script , I am getting two records becoz of different SE.Service Event Record ID .i.e below script
SE: NoConcatenate LOAD DISTINCT "OOS.Derived National Service Event Record Id" as IDKey, [Facility Identifier], "SE.Service Event Record ID", 1 as count_se 0 as count_oos RESIDENT OOS WHERE NOT EXISTS ("Derived National Service Event Record Id","OOS.Derived National Service Event Record Id") ;
Is there any way I get the every first row the the distinct record in RESIDENT table ?
This is an eg , I have to get the distinct record depending on erived National Service Event Record Id not Service Event Record ID. I can understand why my distinct is not working becoz this are two record because of Service Event Record ID
Is there any way in qlikview script where I can only pick the first record ?
