join, keep, applymap

rdsuperlike — Wed, 16 Sep 2015 00:03:59 GMT

My tables t1 and t2 are really huge.

due to the left join, its creating duplicate records in the qvds that I am storing t1 and t2 into .

If i chnage it to left keep the qvd shows unique records and is proper..but it generates map table in the model which is not required.

If i use Drop table map;

at the end after using keep, it drops flag field....any solution here?

load * inline [

field1, field11

a,1

b,2

c,3

];

t2:

load * inline [

field1, field22

a,1

c,3

d,4

];

map: Mapping LOAD field1, 1 Resident t2;

left keep (t1)

load field1, ApplyMap('map', field1, 0) as flag

Resident t1;

Re: join, keep, applymap

settu_periasamy — Wed, 16 Sep 2015 03:05:57 GMT

Hi,

may be like this

map:

Mapping LOAD field1, 1 Resident t2;

t3:

Left Keep(t1)

load field1, ApplyMap('map', field1, 0) as flag

Resident t1;

DROP Table t1;