generic load

[danaleota1]

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];

[rubenmarin]

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