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

[Anonymous]

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;

[sunny_talwar]

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