Vertical Pivot based on conditions

[clmhwyfe]

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'

[ray.wurlod]

No.

But you can filter beforehand or afterwards.

[clmhwyfe]

Thanks Ray,

I will try to filter it before the Pivot stage and update that column via another process.