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