lookup concern

[#1]

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 · Accepted solution]

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 

[#3]

thanks bro