Performing a Preceding load with Join

[dripet]

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

[sunny_talwar · Accepted solution]

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;