Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
1:
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;
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;