Pivoting 1 or more groups in a singel stage
Posted: Mon Jun 13, 2011 3:02 am
Can you please guide me in this following scenario?
I have an input source with the following attributes in my input.
Key,NumericType1,NumericValue1,NumericType2,NumericValue2,NumericType3,NumericValue3,CharType1,CharType2,CharType1,CharType2
I need to pivot Numetic TYpe and CharType as below
Key,NumericType,NumericValue,CharType,CharValue
Iss this possible? I tried grouping, and assignt keys, but no luck. Requesting ur help
I have an input source with the following attributes in my input.
Key,NumericType1,NumericValue1,NumericType2,NumericValue2,NumericType3,NumericValue3,CharType1,CharType2,CharType1,CharType2
I need to pivot Numetic TYpe and CharType as below
Key,NumericType,NumericValue,CharType,CharValue
Iss this possible? I tried grouping, and assignt keys, but no luck. Requesting ur help