Crosstable with specific columns

[Anonymous]

All,

I have struggling been with this query for a while now.

I want to use a Crosstable load to import some excel data. My query is how does one load in data using the crosstable when the "qualifier fields" are in the middle of the dataset. See attached example:

[kaushiknsolanki · Accepted solution]

Hi,

Try this,

CrossTable(Column,Data,2)

Load C,

        E,

        A,

        B,

        D

From Xyz;

You need to remember that you must keep the columns which you need to qualify (Keep as it is) at top in load order.

Just like in your case it will be C and E on top and others at bottom.

Regards,

Kaushik Solanki

[MarcoWedel]

if you can't change the initial load order, then you could use a crosstable resident load from your already loaded table:

table1:
LOAD A,B,C,D,E
From Somewhere;

table2:
CrossTable (Name, Value,2)
LOAD  C,E,A,B,D
Resident table1;

Drop Table table1; 

hope this helps

regards

Marco

[Anonymous]

Great thanks mate