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.