Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I need to do a generic load in order to get the a straight table into a wide pivoted table) I have the script below. It runs gets stuck and I end up aborting the load after about an hour. Any idea what I could be doing. I tried to limit the data by adding the where condition but that didn't help.
Thanks.
temp1:
generic load
EvaluationKey,
TemplateQuestionContent as Attribute,
TemplateAnswer as Value
from [lib://PROD_QlikData/ContactCenter/RepFeedbackForm.qvd](qvd)
where date(floor(dteCallDate)) >= '11/1/2021';
Let vNoOfTables = NoOfTables();
For cnt = 0 to $(vNoOfTables)-1
Let vTableName = TableName($(cnt));
TableList:
LOAD
'$(vTableName)' as TableName
Autogenerate(1);
Next
Let vFirstTableName = Peek('TableName',0,'TableList');
Let vNumberOfRows = NoOfRows('TableList')-1;
For cnt =1 to $(vNumberOfRows)
Let vTableName =Peek('TableName',$(cnt),'TableList');
left Join($(vFirstTableName))
LOAD * Resident $(vTableName);
DROP Table $(vTableName);
Next
Rename Table $(vFirstTableName) to coachingData;
STORE [coachingData] INTO [lib://PROD_QlikData/ContactCenter/coachingData.qvd];
Hi, when you load the tables you are loading all tables in the data model, including temp1 table and maybe others that may exist in the data model, so I think you need to check table names to ensure you are merging only the generic tables, take a loo at this blog post: https://community.qlik.com/t5/Qlik-Design-Blog/The-Generic-Load/ba-p/1473470