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

[grazitti_sapna]

Hi @skotian1289 , give this a try.

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

Thanks.

[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.

[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.

[atcodedog05]

Hi @skotian1289 ,

Did you try replacing the text input tool with your input tool. It should work.

If not please share the file we will check.

[grazitti_sapna]

@skotian1289 , try running the workflow after you change the file then try running it as an app?

If possible can you share the workflow or the file that you are using for further investigation.

One of the possible reason I can think of it is that you need to run the workflow after changing the input source as the workflow stores headers from the previously run workflow as cache, as I am picking up the values from the file itself.

Thanks.

[skotian1289]

Is there a way the tool can get updated automatically for column headers and user doesn't have to run it manually every time a new input file comes in. I tried with 2 attached input files the tool captures the old file column headers in the pop up section. Let me know if its possible

attaching sample inputs.

Thanks

[skotian1289]

Hi,

I did try with 2 different Input Sample. The issue is the pop up section captures the old file column headers instead of new file column headers. Is it possible that tool auto updates the column header list whenever a new file is used. The reason I am asking is User might not be able to run it manually the first time like us for headers to get updated and they might just use it as an app.

I am attaching sample input files which I used for testing the workflow.

Thanks

[atcodedog05]

Hi @skotian1289 ,

Its working for me.

Here is the modified workflow.

Open the app in the designer to change the file.

Hope this helps : ) Please reach out if there are any other concerns.

[grazitti_sapna]

HI @skotian1289 , give this a try I have removed the transformation part and now it is working as expected.