Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
rdsuperlike
Creator
Creator

join, keep, applymap

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;

1 Reply
settu_periasamy
Master III
Master III

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;