Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there ,
T1:
LOAD
NTNAME
Resident SA;
T2:
LOAD
WARD
Resident QVD;
How to get the third table :
T3:
LOAD
NTNAME,WARD
FROM T1 and T2 in qlikview script ?
Hi
If there is no common field, you can use cross join in order to get the 2 fields in one table. Like below,
Load Distinct NTNAME Resident SA;
Join
Load Distinct WARD Resident QVD;