How to update the column header in table tool

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

Workflow

Reporting

Tips and Tricks

Transformation

Accepted answers

Christina_H

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

Change table headers.yxwz

All comments

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

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

Change table headers.yxwz

Quick Links

This months top contributors

LanisC 335

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177