Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi QS Community,
I am trying to create a cross table from the following data so I can build an area graph.
Table Header: CRM#, StrikeRate, 2017-Q1, 2017-Q2, 2017-Q3, 2017-Q4, etc
Example data: 3333, StrikeRate1, 1,2,3,4
I need data to look like this ;
3333, StrikeRate1, 2017-Q1, 1
3333, StrikeRate1, 2017-Q2, 2
3333, StrikeRate1, 2017-Q3, 3
3333, StrikeRate1, 2017-Q4, 4
I can't seem to be able to use the crosstable function with more than one attribute. Is this possible ?
thanks
Neale
you can use crosstable load,
easiest would be you upload an Excel file with some sample data and original header...
Hello,
you can use crosstable load with multiple Attributes. You have to define it in the crossload Option.
Use
Crosstable (Quarter,Value,2) LOAD * from yourdata.
The parameter 2 is
the number of qualifier fields preceding the table to be transformed to generic form. Default is 1.
Regards
Thanks Martin, will give that a go.
NEale
CrossTable (YearQtr, QtrValue, 2)
load CRM#, StrikeRate, 2017-Q1, 2017-Q2, 2017-Q3, 2017-Q4 from XXXXX;
1st Attribute - YearQtr = Name the column (**Can be anything) - The column which you want to be represented as row
2nd Attribute - Values in converted column (Naming convention can be anything)
3rd attribute = no of remaining columns which you want to keep as it is.
Ex;
CrossTable (YearQtr, QtrValue, 4)
load CRM#, StrikeRate, Amount, Colx, 2017-Q1, 2017-Q2, 2017-Q3, 2017-Q4 from XXXXX;
Hi,
look attached file
Andrey