Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
How to use resident load with cross table Load
Thanking You
Vinayagam
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
AAA:
crosstable
....
then you may do
Load * resident AAA;
not togheter
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
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
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;