call field from previous loaded table

[renjithpl]

Hi all,

I have a small scenario. Below is my code and example

First:

Load

A,

B,

C

From table ABC.xlsx;

Second:

Load

X,

If(B=X, A) as Y, // i want to bring B from above loaded script to table"Second" with a condition

From table XYZ.xlsx;

how can i achive this.?

Thanks in advance.

REn

[#2 · Accepted solution]

Hi Ranjit,

below is the sollution:

check if it works and let me know

First:

Load

A,

B,

C

From table ABC.xlsx;

join

Second:

Load

X

From table XYZ.xlsx;

Third:

load *,

If(B=X, A) as Y

resident First;

Drop table First;

[renjithpl]

thanks a lot, dude. it worked. 🙂