How to get two fields from two different table with out common field ?

[ashmitp869]

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 ?

[MayilVahanan]

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;