topic Re: How to get two fields from two different table with out common field ? in QlikView

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

ashmitp869 — Fri, 17 Jun 2022 02:51:09 GMT

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 — Fri, 17 Jun 2022 03:39:09 GMT

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;