topic call field from previous loaded table in QlikView

call field from previous loaded table

renjithpl — Fri, 15 Oct 2010 11:52:56 GMT

Hi all,

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

First:

Load

From table ABC.xlsx;

Second:

Load

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

Fri, 15 Oct 2010 11:57:26 GMT

Hi Ranjit,

below is the sollution:

check if it works and let me know

First:

Load

From table ABC.xlsx;

join

Second:

Load

From table XYZ.xlsx;

Third:

load *,

If(B=X, A) as Y

resident First;

Drop table First;

renjithpl — Fri, 15 Oct 2010 12:08:15 GMT

thanks a lot, dude. it worked. 🙂