Rename Column Header to date from another column

[JSheppard98]

Hi there, I have the current formula to rename my transaction amount column "datetimeformat(datetimeadd(datetimetoday(), -1, 'days'), '%Y-%m-%d')". However, if I was to run this on Monday, it would bring back a weekend date.

So, since my report with the transaction amount in, has a column of "Value Date" with the working day prior date, I was wondering if there is a formula I can use in dynamic rename tool to take the date and then replace "Transaction Amount" header with the "Value Date" ie 1/16/2023? 

Thanks

[FinnCharlton]

Can you use the same formula that calculates "Value Date" in the dynamic rename?

[JSheppard98]

Apologies, the value date column is not formula that is just raw from the input data file itself sadly.

[ShankerV]

Hi @JSheppard98 

Please find the expected output.

Many thanks

Shanker V

[ShankerV · Accepted solution]

Hi @JSheppard98 

Step 1: Input as shown in the Dataset sample.

Step 2: Select tool

Step 3: Sample tool

Many thanks

Shanker V

[binuacs]

@JSheppard98 One way of doing this with the dynamic rename tool

[ShankerV · Accepted solution]

Hi @JSheppard98 

Step 4: Formula tool.

Step 5: Dynamic rename

Output expected:

Feel free to mark the solution of the post which helped to resolve the issue, so similar issues faced by other community members in future can be helpful to refer the solution.

Many thanks

Shanker V

[JSheppard98]

This is perfect, and no need to be dynamic either as the input data will change per value date so this should still all work for a different day ran due to input data changing/updating value date with previous day. Thanks so much!

[ShankerV · Accepted solution]

Hi @JSheppard98 

You can also eliminate the Sample tool, it will deliver you the same result.

If the data is huge, sample tool will help to fasten the workflow as it limits to 1st record.

Feel free to do the modifications in your workflow as both will give the same output.

Many thanks

Shanker V