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 ?