topic Re: Performing a Preceding load with Join in QlikView

Performing a Preceding load with Join

dripet — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I'm working on a project and I wanted to check if this is possible WITH PRECEDING LOAD or the alternative

TableA:

If(X1=1 and Y=1,1,0) as X;

Load

X as X1,

FROM c:\Table1;

Left join (TableA)

Load

From c:\Table2;

Drop field X1 FROM TableA;

Thanks

Re: Performing a Preceding load with Join

sunny_talwar — Wed, 20 May 2020 11:46:20 GMT

It would go something like this

TableA: LOAD *, X as X1 FROM c:\Table1; Left join (TableA) LOAD A, Y From c:\Table2; FinalTableA: LOAD *, If(X1 = 1 and Y = 1, 1, 0) as X Resident TableA; DROP Table TableA DROP Field X1 FROM FinalTableA;