In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

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

Dynamic Column name

bakaidora
8 - Asteroid

Dear All,

 

I have the following use case.

I have an input file, in this input I have a section somewhere in the file where I can find some values which I would like to use later as column name. I say " somewhere" because it can be anywhere BETWEEN the number (14) after [VARBLE INFO] (they number can be 14, 13 or other number as well - it always depends on how many column names we have) and [HISTORY DATA].

 

Example for 14 parameters:

[VARBLE INFO]

14

Pressure        MPa

Temperature     oC

ShearStress     MPa

ShearRate       1/sec

u-Velocity      cm/sec

v-Velocity      cm/sec

w-Velocity      cm/sec

FlowRate        cc/sec

Density         g/cm3

Conversion      %

Scorch_Index    -

Viscosity       Poise

ViscousHeat     J

ReactiveHeat    J

[HISTORY DATA]

 

Example for 13 parameters:

[VARBLE INFO]

13

Pressure        MPa

Temperature     oC

ShearStress     MPa

ShearRate       1/sec

u-Velocity      cm/sec

v-Velocity      cm/sec

w-Velocity      cm/sec

FlowRate        cc/sec

Density         g/cm3

Conversion      %

Viscosity       Poise

ViscousHeat     J

ReactiveHeat    J

[HISTORY DATA]

 

It can happen that next time I will have 15 parameters which I need to use later as column name.

 

Currently, I have 2 workflows 1 workflow for 13 parameters and an other workflow for 14 parameters but I would like to make this more dynamic.

Currently, in the workflow with 13 parameters I rename the columns manually with the Select tool.

bakaidora_0-1665835080566.png

 

As I feel, I need to solve 2 issue:

1. Get the needed column names from the tool --> after the number after [VARBLE INFO] and before [HISTORY DATA].

2. Use this columns names in the Renaming of the Columns dynamically.

 

Could you please help me, how can I solve this?

Thanks, Dóra

11 REPLIES 11
Saranyaram
6 - Meteoroid
Thanks Jay ..opened new thread ..hopes my question gets clarified soon
Saranyaram
6 - Meteoroid

Thanks Jay ..opened new thread ..hopes my question gets clarified soon

Labels
Top Solution Authors