Rename the Field Names using App

Thanks for your time,

I'm building an app where I need to change the field names of an incoming CSV file.

I have used a file browse tool and a drop-down tool to get the CSV data and apply the delimiter.

After that, I took the field names and ask the user which field in the new file is Effective Date after that I used a text input tool to capture that info and then used dynamic rename to finally rename the field.

But my issue is that the drop-down tool that is used to display the field names is not working dynamically.

Not sure what is wrong here, would be really helpful if you could help me.

Field Name Drop down.yxwz

Workflow

Apps

Help

Accepted answers

atcodedog05

Hi @Adarsh_R3

Here is how you can do it.

1st App: Output the field names to a file refer below branch.

2nd App: Configure the dropdown to take options from the options file.

Test -1:

Test -2:

Hope this helps : )

Read File.yxzp

All comments

atcodedog05

Hi @Adarsh_R3

Analytic app has a limitation that it needs to be run has a workflow for the changes to take effect in the app.

You might have to build chained for this.

1st App- Blank App just send the field names to a file.

2nd App- Read option from a file for dropdown.

Hope this helps : )

mtouiti

hi @Adarsh_R3 here is some good resources to help you build your chained apps in alteryx https://community.alteryx.com/t5/Interactive-Lessons/Chaining-Analytic-Apps/ta-p/243120 and https://www.thedataschool.co.uk/brian-scally/chaining-apps-in-alteryx

Best

Adarsh_R3

Hey @atcodedog05 thanks for the suggestion but I'm not able to get the field names from a new file.

What I have done is, like u suggested, build two apps one for reading the data and saving it as a .yxdb file and another app that reads the .yxdb file.