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

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

Sample files.zip

Developer Tools

Accepted answers

atcodedog05

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.

Sample 1 New.xlsx

Select Columns.yxwz

grazitti_sapna

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.

Option-V1-GS.yxwz

All comments

grazitti_sapna

Hi @skotian1289 , give this a try.

If this works for you kindly mark this post as solution.

Thanks.

Option-GS.yxwz

atcodedog05

Hi @skotian1289 ,

Here is a workflow for the task.

Input

App

App 2

Output

Hope this helps : )

If this helps please mark the post as solution.

Select Columns.yxwz

Select Columns2.yxwz

skotian1289

Hi Sapna,

This is exactly what I wanted. But I have a quick question, the input files in our tool is autocaptured by the tool from a specific folder and also everytime this Tool is run we will have a different column header name. So will the list of column names get auto updated everytime the tool takes the file from a folder or will it have to be done manually.

I tried running your below workflow as an app, when I used a different file the list of column names that popped out was for the previous used input file and was not updated

Thanks.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703