RESIDENT LOAD AND CROSS TABLE

[#1]

Hi

How to use resident load with cross table Load

Thanking You

Vinayagam

[alexandros17]

AAA:

crosstable

....

then you may do

Load * resident AAA;

not togheter

[its_anandrjs]

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

[its_anandrjs · Accepted solution]

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

[#5]

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;