topic lookup concern in QlikView

lookup concern

Sat, 11 Feb 2012 08:20:32 GMT

Hi,

I have two tables:

table1:

billno

billdate

amount

table2:

billno

billdate

usercode

i need to make the table1 look like

table1:

billno

billdate

amount

usercode

i used the lookup function, it takes a lot of time.. is there any alternative..

thanks

CELAMBARASAN — Sat, 11 Feb 2012 09:04:57 GMT

Hi,

Try with this type of approach

table1:

Load

billno & billdate as Key,

billno,

billdate,

amount

From

datafile1;

Left Join(table1)

Load

billno & billdate as Key,

usercode

From

datafile2;

If you don't need the Key filed anymore just delete it using Drop Field Key; command.

Hope it helps

Celambarasan

Sat, 11 Feb 2012 19:01:28 GMT

thanks bro