topic Re: Crosstable with specific columns in QlikView

Crosstable with specific columns

Anonymous — Mon, 07 Nov 2016 17:43:19 GMT

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:

Re: Crosstable with specific columns

kaushiknsolanki — Mon, 07 Nov 2016 18:14:16 GMT

Hi,

Try this,

CrossTable(Column,Data,2)

Load C,

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

Re: Crosstable with specific columns

MarcoWedel — Mon, 07 Nov 2016 21:47:59 GMT

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

Re: Crosstable with specific columns

Anonymous — Tue, 08 Nov 2016 09:10:05 GMT

Great thanks mate