How to update the column header in table tool

[Sshasnk]

I have to update the column name from the user input, I can't update it before the table tool because I have to apply the formula on that column.

Example:

I have to change the CCY to the currency entered by the user 

Input for table tool:

Fund	Cost CCY		Post CCY
ABC	123		145
BDC	345		456

If the user inputs EUR it should replace CCY with EUR in table tool or after table tool

Fund	Cost EUR		Post EUR
ABC	123		145
BDC	345		456

[ShankerV]

Hi @Sshasnk 

Please find the below solution.

Input was:

Workflow:

Step 1:

Step 2:

Step 3:

Step 4: Dynamic rename

if contains([_CurrentField_],'CCY') then replace([_CurrentField_],'CCY','<TempCCY>') else [_CurrentField_] endif

Kindly accept this solution if it provided a solution to your question.

Many thanks

Shanker V

[Sshasnk]

@ShankerV  Hi, I mentioned above I have to do it in the table tool or after it, I can't do it before because my formula won't work if I change the name before the table tool :)

[ShankerV]

Hi @Sshasnk 

One way to do this in the table tool is as below.

Input was:

Kindly accept this solution if it provided a solution to your question.

Many thanks

Shanker V

[Sshasnk]

@ShankerV  Hi I am not sure I am not able to explain the issue, but the rename should be dynamic and the user should give the currency and should be updated in table tool. The way you showed is where developer is hardcoded it

[Christina_H · Accepted solution]

You need to use two action tools to update the aliases of both columns in the table tool:

You need to run the workflow as an app to see the names change