cross table

[#1]

how to remove 2 fields while loading table as a cross table?

[Jason_Michaelides]

Just don't define them in the load part of the Crosstable() function.

[#3]

Hi,

Yes Jason is right.

When you do crosstable load script will be genearated for that, You can modify that script to suit according to your need.

So, if you want any field to not to be loaded in cross table then just delete that field from your load statement.

if it is still not clear then post your cross table load script.

[#4]

Sheet3 :

CrossTable(Period, Data, 3)
LOAD *
FROM
[..\Excel\Nielsen_Output_Feb12.xls]
(biff, embedded labels, table is WSP_Sheet3$, filters(
Replace(1, top, StrCnd(null)),
Replace(2, top, StrCnd(null))
));

this is my cross table . and in Data i applied transpose and it consists of 5 columnsw which i need to transpose but out of these 5 fields i dont want 2 fields then wt to do?

[Jason_Michaelides]

Instead of LOAD * use LOAD Field1, FIeld2, Field3 etc...

That way you can choose which fields to include.

[#6 · Accepted solution]

Hi,

Yes, Don't use * rather always list field names which you want to load. If you want to load all the field names then list all the field names.

This is a good development practice and using * can lead you sometimes into problems hard to debug.

To list down all the fields, when you use file wizard to load the data, at the last point you will see a checkbox of

Load All(*), it seems that you have checked it, just uncheck this checkbox then you will be able to see all the field names and then remove the fields which you don't want to load.

To reach to the last point, keep clicking the next in your file wizard and you will see this option when next button becomes unavailable.

...

Ashutosh

[#7]

Sheet3 :

CrossTable(Period, Data, 3)
LOAD *
FROM
[..\Excel\Nielsen_Output_Feb12.xls]
(biff, embedded labels, table is WSP_Sheet3$, filters(
Replace(1, top, StrCnd(null)),
Replace(2, top, StrCnd(null))
));

this is my cross table . and in Data i applied transpose and it consists of 5 columnsw which i need to transpose but out of these 5 fields i dont want 2 fields then wt to do?

[#8]

hi Ashutosh

i got that option load * . and its unckecked but at the same time m nt able to remove fields from that table. and after selecting load * it is nt possible to remove that field... and clickin on finish wil showes result like after selecting Load *. please help me regarding that.......

[#9]

yes i got it........ thanx a lot............