topic Re: Crosstable Concatenate in QlikView

Crosstable Concatenate

Mon, 06 Oct 2014 06:40:29 GMT

I need concatenate 2nos cosstable. please help

Re: Crosstable Concatenate

alexandros17 — Mon, 06 Oct 2014 06:47:11 GMT

You have to reload then then you can concatenate:

if you have

TABA:

crosstable ...

TABB

crosstable:

then do:

TABC:

noconcatenate

load * resident TABA;

concatenate

load * resident TABB;

drop tables TAA, TABB;

Let me know

Re: Crosstable Concatenate

anbu1984 — Mon, 06 Oct 2014 06:50:57 GMT

Concatenate two CrossTables

Re: Crosstable Concatenate

Mon, 06 Oct 2014 07:22:02 GMT

Thank you for quick reply for this. I have still in trouble on this regard.

Please refer my script and error massage at the time of data loading.

PL2012:

CrossTable(DESCRIPTIONS, Data, 5)

LOAD BCOD,

MONTH,

YEAR,

MONTH2,

CLA_CODE,

GROSS_PREMIUM

FROM

(qvd);

PL2013:

CrossTable(DESCRIPTIONS, Data, 5)

LOAD BCOD,

MONTH,

YEAR,

MONTH2,

CLA_CODE,

GROSS_PREMIUM

FROM

(qvd);

PL:

NoConcatenate

LOAD * Resident PL2012;

Concatenate

LOAD * Resident PL2013;

DROP Table PL2012;

Error massage as follows,

Table not found

Concatenate

Load * resident PL2013

Re: Crosstable Concatenate

ashfaq_haseeb — Mon, 06 Oct 2014 07:28:04 GMT

HOW TO CONCATENATE BOTH PIVOT TABLES TOGETHER

Re: Crosstable Concatenate

anbu1984 — Mon, 06 Oct 2014 07:28:18 GMT

Here you will get only one table PL2012, since concatenate happens by default.

Hence there is no table named "PL2013" and you got that error.

PL2012:

CrossTable(DESCRIPTIONS, Data, 5)

LOAD BCOD,

MONTH,

YEAR,

MONTH2,

CLA_CODE,

GROSS_PREMIUM

FROM

(qvd);

PL2013:

CrossTable(DESCRIPTIONS, Data, 5)

LOAD BCOD,

MONTH,

YEAR,

MONTH2,

CLA_CODE,

GROSS_PREMIUM

FROM

(qvd);

EDIT: You dont need this code since concatenate happens by default

NoConcatenate

LOAD * Resident PL2012;

Concatenate

LOAD * Resident PL2013;

DROP Table PL2012;

Re: Crosstable Concatenate

Mon, 06 Oct 2014 09:29:50 GMT

Dear Anbu,

Thank you for reply

I create 2 table named PL2012 & PL2013 but still in same error,

Re: Crosstable Concatenate

anbu1984 — Mon, 06 Oct 2014 09:32:20 GMT

Can you post the script you tried?

Re: Crosstable Concatenate

Mon, 06 Oct 2014 09:55:02 GMT

PL2012:

CrossTable(DESCRIPTIONS, Data, 5)

LOAD BCOD,

MONTH,

YEAR,

MONTH2,

CLA_CODE,

GROSS_PREMIUM

FROM

(qvd);

PL2013:

CrossTable(DESCRIPTIONS, Data, 5)

LOAD BCOD,

MONTH,

YEAR,

MONTH2,

CLA_CODE,

GROSS_PREMIUM

FROM

(qvd);

PL:

NoConcatenate

LOAD * Resident PL2012;

Concatenate

LOAD * Resident PL2013;

DROP Table PL2012,PL2013;

Re: Crosstable Concatenate

anbu1984 — Mon, 06 Oct 2014 09:59:34 GMT

If both the QVD's have same column names, then both will get concatenated automatically. Try this

PL:

CrossTable(DESCRIPTIONS, Data, 5)

LOAD BCOD,

MONTH,

YEAR,

MONTH2,

CLA_CODE,

GROSS_PREMIUM

FROM

(qvd);

PL2013:

CrossTable(DESCRIPTIONS, Data, 5)

LOAD BCOD,

MONTH,

YEAR,

MONTH2,

CLA_CODE,

GROSS_PREMIUM

FROM

(qvd);

PL:

NoConcatenate

LOAD * Resident PL2012;

Concatenate

LOAD * Resident PL2013;

DROP Table PL2012,PL2013;

Re: Crosstable Concatenate

Mon, 06 Oct 2014 10:35:42 GMT

THANKS NOW ITS O.K.

Re: Crosstable Concatenate

Mon, 06 Oct 2014 11:03:26 GMT

Dear anbu,

Thank you . now its ok