
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
generic load
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];

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
