Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello experts,
During the load, my tables are doubled. I am doing a load from qvd:
Table1:
LOAD
customerid,
name,
.....
from[lib://CRM/customer_activity_details.qvd](qvd);
customer_activity_details:
SELECT
customerid,
name,
....
FROM CRM.customer_activity_details;
STORE customer_activity_details into [lib://CRM/customer_activity_details].qvd(qvd);
while loading the data load progress shows:
I think tables are getting concatenated here.
For concatenate, tables should have the same number of columns and all the columns should have same names, if this is the case, then both your tables are getting concatenated in one.
If you don't want it to happen, then use noconcatenate before loading the second table.
Hello,
Thank you for the response Simrankaur.
I did noconcatenate before each load statement. It didnot work.
Regards,
Can you attach just this part in your qvw so that I am able to troubleshoot better?