Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have to develop some rating reports based on the raw data. I have attached sample excel for your info.
In excel Raw data is starting from Row 12. And i want to build tables which are just above to that Raw data.
(Tables highlighted in Yellow color).
I am calculating Trainer 1 Knowledge ratings from P column in Raw data and Trainer 1 Overall rating from Q column. Likewise for Trainer 2 Knowledge ratings from V column in Raw data and Trainer 2 Overall rating from W column.
Other Challenge which i am facing is that Right now we have only 2 trainers, it may be possible that there will be addition of N trainers in future.
So i would be grateful if you could suggest me the optimized way to do that.
Thanks
Sagar
Your data doesn't seem to contain any information about the trainers. You will probably want to use the CrossTable function to pivot the data. See this blog post: The Crosstable Load. You may also want to create a table that maps the scores to the rating labels.
What have you tried and what problems did you encounter?
Gysbert, Column P & Q is for Trainer 1 and V & W is for Trainer 2.
Please refer the calculation done in the output table (highlighted table) for details.
James, I am checking the possibility of Concatenation/generic load/cross table but want to know if any optimized way.
Hi Friends,
This is achieved by Cross table and transformation done using concatenation.
Thanks for your support