Rename fields of multiple tabs of single excel sheet

[Gursharan]

Hello Everyone,

How can we rename fields of multiple tabs of single excel sheet according to the given mapping sheet, How can we achieve this ? Can anyone assist ?

Thanks in advance !

[DataNath]

Hey @Gursharan, one of the options within the Dynamic Rename configuration is to 'Take Field Names from Right Input Rows'. Let's say we have some input data like so:

And a mapping table with these - original - names, and their replacements:

We set up the Dynamic Rename tool like so, which will check the input data for the presence of the 'Lookup' and replace it with the 'Rename' if found, giving us the correct output:

For bringing in multiple sheets, there's a bunch of information on this but this depends on the state of your file. Here's a great article with a flow chart to help determine the best option: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Knowledge-Base/The-Ultimate-Input-Data-Flo...

Demo workflow shown above attached.

[Gursharan]

@DataNath Thanks for your revert, visited the link given by you, but unable to understand how can we rename field names in case of multiple tabs, Can you please help me with the batch macro workflow ?

[DataNath]

@Gursharan can you provide an example of what your files look like and what you expect as the outcome? Hard to get a grasp of what you mean exactly without this.

[Gursharan]

@DataNath Appending two files, Sample Data and Mapping File, want to rename old field names in sample data file with the new field name in the mapping file, Please assist to resolve this . Thanks!

[Raj]

PFA

[Gursharan]

@Raj Thanks for your reply, but there are multiple tabs in a single excel and want to perform for all tabs.

[Raj]

please find the sol attached and mark as sol if it solves the problem

[Gursharan]

@Raj Thanks for your the rply, let suppose we have different column names in each tab want to replace field name of each tab at once, something like iteration till nth tab, at last we have to consolidate all the tab. May be resolved by using batch macro.

[Raj]

Yes you Can use batch Macro for same
please find a macro which will help to do so
Just for Reference.

Happy weekend.!!