Dynamic Rename and Formula change

[pbalasubramaniam]

Hello All,

I am trying to rename a file dynamically every time I run a excel File. For instance, I want to rename the Current On-hand to a Specific date. And I want the reamed column to reflect on the Formulas as well automatically. Can you please suggest me a way to Rename the column once and it gets reflected automatically at the specified sites.

All your help will be greatly appreciated.

[Yoshiro_Fujimori]

Hi @pbalasubramaniam ,

Once [Current On Hand] is renamed to [2023-04-12], there is not [Current On Hand] on the table any more.

At this point, the expression

[Current Changes] = [Current On Hand] - [2023-04-12]

will cause an error.

Could you clarify how you avoid the error?

[pbalasubramaniam]

Hello Yoshiro,

Thank you for your response. I have to rename the "Current On hand" to a specific date every time I run this workflow. I want the renamed column name to be reflected in all formulas. For example, If I change the "Current On hand" to "2023-05-02", I want it to be reflected in all formulas without changing them individually. Is there a way to change or update a source and the formulas pulls the date from the updated source.

Thanks....Praveen

[Yoshiro_Fujimori]

@pbalasubramaniam ,

You may want to use Dynamic Replace tool.

First you edit the expression with Formula tool and apply to the data using Dynamic Replace tool.

The sample workflow of Dynamic Replace and Tool Mastery article will help.

Good luck!