Rename Column Header to date from another column

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

Input

Tips and Tricks

Date Time

Accepted answers

ShankerV

Hi @JSheppard98

Step 1: Input as shown in the Dataset sample.

Step 2: Select tool

Step 3: Sample tool

Many thanks

Shanker V

ShankerV

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

ShankerV

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

All comments

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

Hi @JSheppard98

Step 1: Input as shown in the Dataset sample.

Step 2: Select tool

Step 3: Sample tool

Many thanks

Shanker V

binu_acs

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

Dynamic_Rename_011723.yxmd

ShankerV

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!

Quick Links

This months top contributors

LanisC 335

hhaigh1 280

erich_shiino 280

FláviaB 262

JORGE4900 235