Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Complex Header Name

SH_94
11 - Bolide

Dear Community, 

 

I would like to seek for help if anyone know how to convert the original data header to the result as per screenshot below:

SH_94_0-1641715916402.png

 

The challenging part is i need to combine different row header as one and also need to remove ( ) symbol starting from column I before combining it. 

 

Output

SH_94_1-1641715938957.png

 

 

I have also attached the excel file below for your reference.

 

Many thanks again in advance

 

4 REPLIES 4
atcodedog05
22 - Nova
22 - Nova

Hi @SH_94 

 

Here is how you can do it. The workflow is dependent on row number of header hence adjust row header number as required in the select record tool (highlighted below). Let me know if you face any issues.

 

Workflow:

atcodedog05_1-1641717392519.png

 

Hope this helps : )

ponraj
13 - Pulsar

Attaching a sample workflow. Hope this is helpful. 

 

Capture.PNG

binuacs
19 - Altair

@SH_94  

 

binuacs_0-1641743250333.png

 

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @SH_94 

Cheers and have a nice day!

Labels