Giving Option to User to Select a Column and Creating a new column with that values

[skotian1289]

Hello Community,

I am not sure if the below is achievable but worth a shot since we have lot of intelligent brains in our community. 🙂

I am trying to create an interface where the user will have the option to select a Column header and then tool creates a new Column and pastes that value under that column. Its ok if Alteryx does not have an option to do that but I am just trying my luck. See below samples for better understanding.

1.) Sample Input: Tool takes the input file and then throws a question to User.

2.) Question to User:  "Select 1 Column which should be Common Field?"  Options: List of all Column headers in the Input file

3.) Tool Should create output based on selection of user.

See the sample input and outputs for better understanding. I know Alteryx gives an option to user to select thing but I am not sure if it will create a new column with selected column values based on user selection hence I am reaching out for suggestions.

Thanks

[skotian1289]

Hi Sapna,

I think alteryx cannot update an app in real time and hence the interface list doesn't get updated everytime a new file is used. I think chained app is the solution for this limitation and I will try that.

I will mark your reply as a solution because it solves my purpose its just that I have to add lil more steps to it. Just a small question the workflow provided by you to pick up the list of column names is giving a parse error when there are 2 words involved.   column name eg: "User Name" or "Birth Date" is giving a parse error saying unknown variable "User" or "Birth" .

How can we read the entire column name as is and populate it in our interface list .

Thanks

[atcodedog05]

Hi @skotian1289 ,

As you said chained app is a solution.

To make it dynamic you can get your first app to get the file location by file browse interface.

I will check on the 2 word and get back to you. Ideally it should work.

[atcodedog05 · Accepted solution]

Hi @skotian1289 ,

I renamed two columns in the excel file to provided names and its working.

Here is a snapshot.

Output

Workflow

You can change the drop down to list just change the interface too refer previous posts in the trail.

I have attached the files.

Hope this helps : )

If this hepls please mark the post as solution.

[grazitti_sapna · Accepted solution]

Hi @skotian1289 , I came up with a solution and would need you to test it over different cases. If is working fine for me.

I have added dynamic rename tool to replace spaces with _ and back _ with space.

Output

Thanks.