Changing Header Name Dynamically using table header input

Hi Community

I had read few post regarding how to change the header name dynamically but i have few criteria which i didn't see in other post.

In my original source file , there are various of header (more than 30) and below is the dummy header name for the reference.

I plan to rename them accordingly and i have prepare the summary of table on the header name as below:

There are two things which i would like to seek for assistance.

1. May i know how to generate out all the header name in the format above (after consolidating all the file) as i want to prepare the table name (desired name) as per screenshot above

2. After preparing the table name, May i know how can i build the workflow to change the header name dynamically based on the table name that i required?

Changing header name.xlsx

Common Use Cases

Accepted answers

All comments

mceleavey

Hi @SH_94 ,

I've read this a number of times and I still don't understand what you're trying to do.

The data doesn't make much sense. Are you saying that row 1, 6 and 11 are header rows? What logic are you using to output the new headers? Are you wanting to dynamically create the second table?

I don't understand.

atcodedog05

Hi @SH_94

@SH_94 wrote:
There are two things which i would like to seek for assistance.
1. May i know how to generate out all the header name in the format above (after consolidating all the file) as i want to prepare the table name (desired name) as per screenshot above
2. After preparing the table name, May i know how can i build the workflow to change the header name dynamically based on the table name that i required?

Based on your questions

1. You want get a list of existing header names and do some data manipulation to get to desired header.

How you can do that is use a field info tool to get field names, union them all together to get a consolidate list, use data data cleanse tool to remove punctuations and leading/trailing spaces. Then i am using a formula tool to generate desired headers.

The logic i could understand is

IF [Desired Headers] in ("Total amount after the year","Total amount in the year") THEN [Desired Headers] 
ELSEIF [Desired Headers]="Total amount" THEN "SH-Total number"
ELSE "SH-"+[Desired Headers] ENDIF

Refer the below workflow where i am doing the same. You can change the logic based on your requirement.

2. You want to rename the older headers with new headers.

Using dynamic rename tool I am configuring it to look for old header names and replace with new headers name from the created summarize table. Using take field names right input rows config. Refer the below workflow.

Hope this helps 🙂

Header change.yxmd

danilang

hi @SH_94

Good solution from @atcodedog05, here. The only suggestion that I would make is to take the matching logic out of the formula tool. Having it hardcoded makes the workflow difficult to maintain. Instead of this, add your header mapping table as an input, either .csv or .xlsx and use a Join or Find Replace on Original Header Name. This way if the you need to add more mappings, you just add a new line in the mapping table

Dan

SH_94

Hi @mceleavey ,

Sorry for the confusion caused.

The header name will be row 2, 7,and 12. I plan to use dynamic rename tool to rename it but i plan to use the header name that i want for the output result as below.

For the second table, i plan to rename it in the local desktop and upload into the alteryx and ask the alteryx to change the header name accordingly.

SH_94

Hi @atcodedog05 ,

Thank you for your prompt response. As i would like to control the header name mapping table , i plan to do it in the local desktop and input it in the alteryx and use the dynamic rename to replace the header name accordingly.

Currently, i am using batch macro to input all the data file and all already in the consolidated version. Could you guide me how to use the above method (input the table name from local desktop) and change it in the alteryx ( replace the older header name with new header name).

Thank you.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703