Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
robindc
Contributor
Contributor

Load Editor stuck on 'Starting to load'

Hi!

 

I've ceated a QVD containing about 194M records and about 11 columns.

Now, I want to load this QVD in the data load editor and build some logic on it. 

This is the code I would like to execute:

TRANS_FLAGS_UNIQUE:

LOAD 
     Min(ACTIONDATE) as Date,
     Year,
     Month,
     Day,
     Hour,
     CAMPAIGNID,
     ACTIONID,
     PROBEID,
     USERID,
     SUM(Opened) as Unique_Opened,
     SUM(Clicked) as Unique_Clicked,
     SUM(Optout) as Unique_Optout
FROM [lib://Manual Data Shared Folder/rdeconin/CRM RMD Campaign Analysis/QVD/RAW_F_RAWFLAGS.qvd]
(qvd)
group by CAMPAIGNID, ACTIONID, PROBEID, USERID;

join

TRANS_FLAGS_ALL:

LOAD 
     Min(ACTIONDATE) as Date,
     Year,
     Month,
     Day,
     Hour,
     CAMPAIGNID,
     ACTIONID,
     PROBEID,
     FLAGID,
     USERID,
     SUM(Opened) as All_Opened,
     SUM(Clicked) as All_Clicked,
     SUM(Optout) as All_Optout
FROM [lib://Manual Data Shared Folder/rdeconin/CRM RMD Campaign Analysis/QVD/RAW_F_RAWFLAGS.qvd]
(qvd)
group by CAMPAIGNID, ACTIONID, PROBEID, USERID,FLAGID;

When I start the data load, it keeps saying: 'Started loading data'.

How can I fix this? When I load in the QVD without any additional logic, it takes around 3 minutes.

 

Thanks!

Labels (2)
0 Replies