Free Trial

Alteryx Designer Desktop Discussions

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

Dynamic Header name based on the File name Vlalue

Yogish
6 - Meteoroid

Hi 

I have a scenario where there two fields with Filename(String) and Value(Double). 

Here Value header name should be updated based on the Filename's data. 

 

Ex., if Filename contains IS_USD then my the other header name of Value should become as USD_Value else 
if Filename contains IS_Local then the other header name of Value should become as Local_Value. 

 

 

Yogish_0-1676982690346.png

 

3 REPLIES 3
OllieClarke
15 - Aurora
15 - Aurora

Hey @Yogish 

 

You can use the dynamic rename to do this:

OllieClarke_0-1676983336633.png

If you wanna test, then you can tick or untick the first detour tool and check the output

 

Hope that helps,

 

Ollie

 

Christina_H
14 - Magnetar

Here's a quick solution using a crosstab tool to set the header

Christina_H_0-1676983457584.png

 

Yogish
6 - Meteoroid

Thanks Christina_H, It worked :-)

Labels
Top Solution Authors