How change column header using another column value.

[anonymous008_G]

Hi - Can someone please tell me how would I change Gross column header as NewHeader column value. Basically I want Gross column name should be renamed as per value from NewHeader column.

Sector	Gross	Net	NewHeader
Short	100	200	Short
Maturity[1,3)	50	60	Short
Maturity[3,5)	10	20	Short

[binuacs · Accepted solution]

@anonymous008_G one way of doing this

[anonymous008_G]

@binuacs -- Thank a lot, this is really helpful. 

[anonymous008_G]

@binuacs -- I need one more help regarding same project. My condition is if my table consist Long column then data from Long column to be copy over to Long Final column ELSEIF table consist Short column then data from Short column to be copy over to Short Final column ELSE 0 or empty. How would i do this? Currently in below sample table only Short column is exist and i cannot write expression for Long column in formula tool but Long column can come in the next month reporting instead of small. So i wanted to make sure either long or Short any column appears in the reporting this workflow should work both cases. 

RecordID	Sector	Net	Short	Long Final	Short Final
1	Short	100	-100
3	Maturity 3	60	-60
2	Maturity 1	40	-40

[binuacs · Accepted solution]

@anonymous008_G let me know the attached workflow works for you 

[anonymous008_G]

Please ignore, I have solved this using other way. thanks for your help @binuacs 

[anonymous008_G]

thanks Let me try this.