Column Name Not Constant

[harsh30]

Hello,

I am creating a workflow that uses two input files in which column names are not constant in all the files. I have to use three columns in rest of the workflow. I am not finding any way to make this workflow dynamic. Any lead will highly appreciated. 

[christine_assaad]

HI @harsh30 

You can check Dynamic Select. Please see below. Hope it helps. Cheers!

https://help.alteryx.com/current/designer/dynamic-select-tool

[harsh30]

Thanks for your prompt reply.

I have to use column names in formula tool in my rest of the workflow. I don't know how dynamic select will help me.

[christine_assaad]

Hi @harsh30 

You can check out the examples that come with Designer. Below is a snapshot. Hope it helps.

[harsh30]

Hi @ christine_assaad

It will help me to select the columns. But how I will use the column name in my formula tool in my workflow.

Attached screenshot for your reference.

[christine_assaad · Accepted solution]

Hi @harsh30 

You can use Dynamic rename to rename your columns similar to the below. Does this help?