Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
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
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
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
Great thanks mate