Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
dripet
Contributor
Contributor

Performing a Preceding load with Join

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,

A,

B

FROM c:\Table1;

Left join (TableA)

Load

A,

Y

From c:\Table2;

Drop field X1 FROM TableA;

 

Thanks

1 Solution

Accepted Solutions
sunny_talwar

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;

View solution in original post

1 Reply
sunny_talwar

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;