I think this cross table should be easy but I can't get my head around it. My source data looks like this
I want to load it into this
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)
Hi Anand - I think I lost half your reply?
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.
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.
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?
Which fields but on your sample file structure looks good for the result that you want.
Retrieving data ...