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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
sumanta12
Creator II
Creator II

Partial reload with Left join issue

Hi,

When I am doing full load for the below joining table it's working fine & creating a single table:

XXX_WRITE:
LOAD
Key,
TIMESTAMP(MAX(CreatedAt_481ddbd92ed2493bb5ce1eabab8f815b))    AS MAX_TIME
FROM [lib://VVVXXX/XXXWB.qvd](qvd)
GROUP BY Key ;


LEFT JOIN(XXX_WRITE)


LOAD
Key,
CreatedAt_481ddbd92ed2493bb5ce1eabab8f815b                 AS MAX_TIME,
"Feedback",
User
FROM [lib://VVVXXX/XXXWB.qvd](qvd);

 

 

But When I am doing Partial reload and using below script it is not creating a single table instead it is creating 2 tables with synthetic key.

 

XXX_WRITE:
ADD LOAD
Key,
TIMESTAMP(MAX(CreatedAt_481ddbd92ed2493bb5ce1eabab8f815b))    AS MAX_TIME
FROM [lib://VVVXXX/XXXWB.qvd](qvd)
GROUP BY Key ;


LEFT JOIN(XXX_WRITE)


ADD LOAD
Key,
CreatedAt_481ddbd92ed2493bb5ce1eabab8f815b                 AS MAX_TIME,
"Feedback",
User
FROM [lib://VVVXXX/XXXWB.qvd](qvd);

 

How to get a single table after join in case partial reload ?

Labels (4)
0 Replies