topic How to split Qvd into saparate partition Qvds in Qlikview? in QlikView

How to split Qvd into saparate partition Qvds in Qlikview?

Anonymous — Mon, 29 Sep 2014 05:33:59 GMT

Hi..

I have one qvd i want to saparate Single Qvd into different Qvds absed on month. plaease help me..

Please find following attachment attachment contains Qvd Related data..

Regards,

Chandini.G

Re: How to split Qvd into saparate partition Qvds in Qlikview?

sushil353 — Mon, 29 Sep 2014 06:01:34 GMT

Hi,

Try below code:

Temp:

LOAD Distinct MonthName(Date_DATE_TIME) as Dates

FROM

IVRREPORTDATA_CALLINFO.qvd

(qvd);

let vrows = NoOfRows('Temp');

for i=0 to $(vrows)-1

let vMonth = peek('Dates',$(i),'Temp');

table:

LOAD CallID,

ApplicationID,

CallDateTime,

Date_DATE_TIME,

Time_DATE_TIME,

SessionID,

Status,

ABANDONED_FLAG,

CALL_END_REASON,

CALLID,

CALLORIGINTYPE,

CATEGORY,

SUBCATEGORY,

CIRCLEID,

CLI,

DISPOSITION,

CALLINFO_DNIS,

DTMFPATH,

ENDDATETIME,

ENDTYPE,

ERR_REASON,

GATEWAYIP,

HOW_CALL_ENDED,

HUB,

ICR,

LANGCODE,

LASTMENUACCESSED,

MENUPATH,

MOBILENUM,

RTR_CL_KEY,

RTR_CL_KEY_DAY,

RTR_SEQ_NUM,

KEY_COLUMN,

SERVICEPATH,

SESSIONID,

STARTDATETIME,

TPIN_BLOCKED,

TPIN_CHANGED,

TPIN_RESET,

TRANSCODE,

TRANSFERVDN,

TRANSTOIVR,

VXMLIP,

MANAGEDACCESS,

XFERBARRED,

IVRBARRED,

RESERVE1,

RESERVE2,

RESERVE3,

RESERVE4,

RESERVE5,

RESERVE6,

RESERVE7,

RESERVE8,

RESERVE9,

RESERVE10

FROM

IVRREPORTDATA_CALLINFO.qvd

(qvd)

where MonthName(Date_DATE_TIME) = '$(vMonth)';

store table into table_$(vMonth).qvd(qvd);

DROP Table table;

NEXT i;

HTh

Sushil

Re: How to split Qvd into saparate partition Qvds in Qlikview?

Anonymous — Mon, 29 Sep 2014 06:23:20 GMT

Hi Shushil..

Thanks For your response...

which I table i have to drop here..

Re: How to split Qvd into saparate partition Qvds in Qlikview?

sushil353 — Mon, 29 Sep 2014 06:29:10 GMT

Hi, Didn't get your question..

You can create a temp_table for storing the data into qlikview..

If your issue is fullfilled then mark the thread as answered so that other get benifit..

Re: How to split Qvd into saparate partition Qvds in Qlikview?

Anonymous — Mon, 29 Sep 2014 06:37:06 GMT

Hi..

In code we mentioned

store table into D:\chandini\New folder\Qvds\Month\table_$(vMonth).qvd(qvd);

so month wise data tables stores in D:\chandini\New folder\Qvds\Month in path but i didnot find any tables in path.

Thanks,

Chandini.G

Re: How to split Qvd into saparate partition Qvds in Qlikview?

sushil353 — Mon, 29 Sep 2014 06:50:48 GMT

Hi,

This is working for me..

You will get table_Aug 2014.qvd in the path specified.

if still, you face any issue then post your code.

Re: How to split Qvd into saparate partition Qvds in Qlikview?

Anonymous — Mon, 29 Sep 2014 06:59:21 GMT

Hi ..

I didnot get...

My code is

Temp1:

LOAD Distinct MonthName(Date_DATE_TIME) as Dates

FROM

D:\chandini\New folder\Qvds\IVRREPORTDATA_CALLINFO.qvd

(qvd);

let vrows = NoOfRows('Temp');

for i=0 to $(vrows)-1

let vMonth = peek('Dates',$(i),'Temp1');

table:

LOAD CallID,

ApplicationID,

CallDateTime,

Date_DATE_TIME,

Time_DATE_TIME,

SessionID,

Status,

ABANDONED_FLAG,

CALL_END_REASON,

CALLID,

CALLORIGINTYPE,

CATEGORY,

SUBCATEGORY,

CIRCLEID,

CLI,

DISPOSITION,

CALLINFO_DNIS,

DTMFPATH,

ENDDATETIME,

ENDTYPE,

ERR_REASON,

GATEWAYIP,

HOW_CALL_ENDED,

HUB,

ICR,

LANGCODE,

LASTMENUACCESSED,

MENUPATH,

MOBILENUM,

RTR_CL_KEY,

RTR_CL_KEY_DAY,

RTR_SEQ_NUM,

KEY_COLUMN,

SERVICEPATH,

SESSIONID,

STARTDATETIME,

TPIN_BLOCKED,

TPIN_CHANGED,

TPIN_RESET,

TRANSCODE,

TRANSFERVDN,

TRANSTOIVR,

VXMLIP,

MANAGEDACCESS,

XFERBARRED,

IVRBARRED,

RESERVE1,

RESERVE2,

RESERVE3,

RESERVE4,

RESERVE5,

RESERVE6,

RESERVE7,

RESERVE8,

RESERVE9,

RESERVE10

FROM

D:\chandini\New folder\Qvds\IVRREPORTDATA_CALLINFO.qvd

(qvd)

where MonthName(Date_DATE_TIME) = '$(vMonth)';

store table into D:\chandini\New folder\Qvds\Month\table_$(vMonth).qvd(qvd);

DROP Table table;

NEXT i;

Re: How to split Qvd into saparate partition Qvds in Qlikview?

Anonymous — Mon, 29 Sep 2014 07:09:29 GMT

Hi..

I got it its working fine..

Thanks,

Chandini