topic Re: Can we concatenate two Crosstables? in QlikView

Can we concatenate two Crosstables?

Tue, 16 Sep 2014 09:37:25 GMT

Hi ,

I am loading two crosstables as given below. Is it possible to merge these two cross tables.

MonthlyIndPara:

CrossTable(ParameterMonth, Data, 2)

LOAD

Name,

Parameters,

[Jan-2014],

[Feb-2104],

[Mar-2014],

[Apr-2014],

[May-2014],

[Jun-2014],

[Jul-2014],

[Aug-2014],

[Sep-2014],

[Oct-2014],

[Nov-2104],

[Dec-2014]

FROM

[RawData.xlsx]

(ooxml, embedded labels, table is Parameters);

MonthlyAttendance:

CrossTable(PresentMonth, PresentDays, 2)

LOAD Team,

Name,

[Jan-2014],

[Feb-2104],

[Mar-2014],

[Apr-2014],

[May-2014],

[Jun-2014],

[Jul-2014],

[Aug-2014],

[Sep-2014],

[Oct-2014],

[Nov-2104],

[Dec-2014]

FROM

[RawData.xlsx]

(ooxml, embedded labels, table is Attendance);

Re: Can we concatenate two Crosstables?

deepakqlikview_123 — Tue, 16 Sep 2014 09:49:23 GMT

use resident load for both table.

Concatenate both tables and

drop origioal tables.

Thanks

Re: Can we concatenate two Crosstables?

MayilVahanan — Tue, 16 Sep 2014 09:56:34 GMT

You need to use Resident table in order to concatenate the cross tables. After concatenate, you can able to drop the original tables.

If you have many cross table and need to join with one table, then try like below

// Retrieve the table names
FOR i = 0 to NoOfTables()

TableList:

LOAD TableName($(i)) as Tablename AUTOGENERATE 1;

// here u can specify condition like WHERE WildMatch(TableName($(i)), '*Month*');"

NEXT i

//Join with Sales Table
FOR i = 1 to FieldValueCount('Tablename')

LET vTable = FieldValue('Tablename', $(i));

Concatenate(Sales)LOAD * RESIDENT $(vTable); // Concatenate with sales table

DROP TABLE $(vTable);

NEXT i

//Drop the unwanted table
DROP TABLE TableList;

Hope it helps

Re: Can we concatenate two Crosstables?

Tue, 16 Sep 2014 11:29:47 GMT

I am new to qlikview.

Can you please show me an example.

Re: Can we concatenate two Crosstables?

deepakqlikview_123 — Tue, 16 Sep 2014 11:36:16 GMT

MonthlyIndPara:

CrossTable(ParameterMonth, Data, 2)

LOAD

Name,

Parameters,

[Jan-2014],

[Feb-2104],

[Mar-2014],

[Apr-2014],

[May-2014],

[Jun-2014],

[Jul-2014],

[Aug-2014],

[Sep-2014],

[Oct-2014],

[Nov-2104],

[Dec-2014]

FROM

[RawData.xlsx]

(ooxml, embedded labels, table is Parameters);

MonthlyAttendance:

CrossTable(PresentMonth, PresentDays, 2)

LOAD Team,

Name,

[Jan-2014],

[Feb-2104],

[Mar-2014],

[Apr-2014],

[May-2014],

[Jun-2014],

[Jul-2014],

[Aug-2014],

[Sep-2014],

[Oct-2014],

[Nov-2104],

[Dec-2014]

FROM

[RawData.xlsx]

(ooxml, embedded labels, table is Attendance);

Final:

Load * Resident MonthlyIndPara;

Concatenate(Final)

load * Resident MonthlyAttendance;

Drop Table MonthlyIndPara;

Drop Table MonthlyAttendance;

Thanks

Re: Can we concatenate two Crosstables?

Wed, 17 Sep 2014 07:12:22 GMT

Thanks for your answer.