Rename the Field Names using App

[Adarsh_R3]

Hi 

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.

[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

Mo

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

But the problem still remains the same i.e the drop-down is not updating dynamically. 

[atcodedog05]

@Adarsh_R3 

Oh, can you provide sample file.

[Adarsh_R3]

I've attached two CSV files. Both with different headers 

[atcodedog05 · Accepted solution]

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 : )

[atcodedog05]

Hi @Adarsh_R3 

Refer this interactive lesson for better understanding.

Hope this helps : )

[Adarsh_R3]

@atcodedog05 @mtouiti 

Thanks a lot, guys... 

Was stuck with this for a while.. 

[atcodedog05]

Happy to help : ) @Adarsh_R3