Hi all,
Am using a vertical pivot , but a new requirement is not working and am not sure on the change.
Initially Data was available as shown below and I was able to do the veritcal pivot as Value_1, Value_2, Value_3
ID SEQ_ID VALUE
1 | 1 | A
1 | 2 | B
1 | 3 | C
2 | 1 | X
2 | 2 | Y
but now they have a new vaue in the SEQ_ID which could be an alphabet (A) and I need to populate column 'Value_Attribute' with the value only if SEQ_ID = 'A' , there are instances where some of the groups dont have a SEQ_ID = 'A' so when i sort the data based on the ID and SEQ_ID , my values are getting interchanged in instances where there are no SEQ_ID = 'A'
Kinldy let me know if we can specify a condition in the Pivot stage to populate the 'VALUE_ATTRIBUTE' only if the SEQ_ID is 'A'
Vertical Pivot based on conditions
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: