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
Solved! Go to Solution.
Can you use the same formula that calculates "Value Date" in the dynamic rename?
Apologies, the value date column is not formula that is just raw from the input data file itself sadly.
Hi @JSheppard98
Step 1: Input as shown in the Dataset sample.
Step 2: Select tool
Step 3: Sample tool
Many thanks
Shanker V
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
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!
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