Crosstable

[georgina_spary]

I think this cross table should be easy but I can't get my head around it. My source data looks like this

Student	Course
123	A
123	B
124	A
124	B
124	G
125	D
125	F
125	G
126	D
126	F
127	D
127	F
128	E
129	E
130	A
131	B

I want to load it into this

Student	A	B	D	E	F	G
123	1	1
124	1	1				1
125			1		1	1
126			1		1
127			1		1
128				1
129				1
130	1
131		1

...?

[its_anandrjs]

Hi,

There is no need of cross table creation you have to load your table with Student and Course and then after reloading create a pivot table

and on that take

Dimension :Student, Course

Expression : Count(Course)

HTH

Regards,

Anand

[#3]

Hi,

You can simply use the File Wizard while loading data from the source.

Use Enable Transformation Step -- Rotate tab and select Transpose to achieve the result.

Hope that help.

Regards,

-Khaled

[georgina_spary]

Hi Anand - I think I lost half your reply?

[georgina_spary]

Nice idea. but at the moment one of my fields is an applymap. I can change it of course. Both teh main load and the mapping load are from qvds but that should be OK?

[georgina_spary]

Aha, got it. Yes that would be OK except I'm building a transformation table and will be doing a number of transformations on A,B, C, etc, so I was hoping to set up something tidy at teh early load stage.

[its_anandrjs]

Hi,

Which fields but on your sample file structure looks good for the result that you want.

Regards,

Anand