while running script using Group By Function creates space problem in C drive .

Anonymous — Fri, 03 Feb 2017 10:04:34 GMT

Hi All ,

I am facing a problem in running the Qlikview script having a Group by function in it ,While loading the script it is consuming the space of C:drive and taking too much time to reload . Also when I re-start my server after aborting the same application everything seems to be perfect .

Here is my code script below .. Should i try to optimize or there is another cause of this . Help ..!

LcsCDR1:

LOAD Distinct *,

if(match(Media_Type,'Audio/Video','conf:audio-video', 'Audio'),'Audio-Video',

if(match(Media_Type,'Application Sharing','conf:applicationsharing','LYNC Sharing'),'Application Sharing',

if(match(Media_Type,'Chat/IM','IM','conf:chat'),'Chat',

if(match(Media_Type,'File Transfer','File transfer'),'File Transfer',Media_Type)))) as MediaType

Resident Fact;

DROP Table Fact;

DROP Field Media_Type FROM LcsCDR1;

LcsCDR:

NoConcatenate

LOAD CId,

ConfURI,

Month_Name_Year,

SUM(DureeSession) as DureeSession,

Count(DISTINCT ADUser_Mail) as Count_ADUser_Mail,

MediaType,

Pool,

//ClientVersion,

LCS_QOE_Key,

LCS_QOE_Key1,

Call_Type_Lcs

Resident LcsCDR1

Group BY CId,

ConfURI,

Month_Name_Year,

MediaType,

Pool,

//ClientVersion,

LCS_QOE_Key,

LCS_QOE_Key1,

Call_Type_Lcs;

Drop Table LcsCDR1;

Re: while running script using Group By Function creates space problem in C drive .

sunny_talwar — Fri, 03 Feb 2017 10:27:20 GMT

Based on the number of records Group By can be extremely resource intensive. How many rows of unaggregated data do you have here?

topic while running script using Group By Function creates space problem in C drive . in QlikView

while running script using Group By Function creates space problem in C drive .

Re: while running script using Group By Function creates space problem in C drive .