Generic Load Issues

[Lena4]

Is there an alternative to Generic Load to unpivot data?  I've tried using a loop to join the tables after the fact, but Qlik keeps crashing, and just says that the process was 'aborted' with no other explanation. I do have a lot of data so that could be the issue

I ultimately want to get the data in one table so then I can merge another table for comparison of the values in each table at a given point in time. Here's an example of the data. 

[rubenmarin · Accepted solution]

Hi, you can try loading fewer values and check if something is working unexpectedly in the joining.

As a workaround I think in a script like:

NeedTable:
NoConcatenate
LOAD FieldValue('TimeStamp',RecNo()) as TimeStamp
AutoGenerate FieldValueCount('TimeStamp');

FOR vNumValue=1 to FieldValueCount('Location')
	LET vLocationValue = FieldValue('Location',$(vNumValue));
	
	Left Join (NeedTable)
	LOAD
		TimeStamp,
		Value as [$(vLocationValue)]
	Resident CurrentTable
	Where Location=$(vLocationValue);
NEXT	

DROP Table CurrentTable;

[Lena4]

Thanks, I'll give that a try