topic Re: RESIDENT LOAD AND CROSS TABLE in QlikView

RESIDENT LOAD AND CROSS TABLE

Fri, 20 Nov 2020 18:02:30 GMT

How to use resident load with cross table Load

Thanking You

Vinayagam

Re: RESIDENT LOAD AND CROSS TABLE

alexandros17 — Wed, 26 Mar 2014 13:31:00 GMT

AAA:

crosstable

....

then you may do

Load * resident AAA;

not togheter

Re: RESIDENT LOAD AND CROSS TABLE

its_anandrjs — Wed, 26 Mar 2014 13:33:21 GMT

Hi,

1. Resident Load

TableName:

Load

FieldName1,

FieldName2

....

From Location;

ResidentTable:

Load

Resident TableName;

Drop Table TableName;

Drop is required because data concatenate

2.Cross Table laod

TableName:

CrossTable(Location, Data, 2)

LOAD

Location,

[Sub Group],

AP,

MP,

UP,

Kerala,

Delhi

FROM

Location;

Hope this helps

Thanks & Regards

Re: RESIDENT LOAD AND CROSS TABLE

its_anandrjs — Wed, 26 Mar 2014 13:36:31 GMT

First Cross load and then resident load

TableName:

CrossTable(Location, Data, 2)

LOAD

Location,

[Sub Group],

AP,

MP,

UP,

Kerala,

Delhi

FROM Location;

ResidentTable:

Load *

Resident TableName;

Because Resident is from base table.

Hope this helps

Thanks & Regards

Re: RESIDENT LOAD AND CROSS TABLE

Wed, 26 Mar 2014 18:42:14 GMT

I am tryng to do the same has mentioned above but its not wrkig pls help

TABLE1:

CrossTable(DATE1, Data,2)

LOAD

LEFT(FileName (),6) AS FileDate,

Name,

[1],

[2],

[3],

[4],

[5],

[6],

[7],

[8],

[9],

[10],

[11],

[12],

[13],

[14],

[15],

[16],

[17],

[18],

[19],

[20],

[21],

[22],

[23],

[24],

[25],

[26],

[27],

[28],

[29],

[30],

[31]

FROM

[032014.xls]

(biff, embedded labels, table is DATA$);

TABLE2:

LOAD *

Resident TABLE1;

DROP Tables TABLE1;