topic Re: Generic Load Issues in App Development

Generic Load Issues

Lena4 — Fri, 16 May 2025 22:43:48 GMT

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.

Re: Generic Load Issues

rubenmarin — Sat, 17 May 2025 07:31:32 GMT

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;

Re: Generic Load Issues

Lena4 — Mon, 19 May 2025 14:12:23 GMT

Thanks, I'll give that a try