Macro - Select File

[MarkBurns]

Hi All 

Could do with a bit of help on this macro please.  it should allow the user to select one of three input files via radio buttons, which will then update the file path for the input tool.

Added a summarise just to see an aggregated output, this stage will be added to a flow that renames columns and cleans up the input data ready for processing, but for the life of me I can seem to the path to update.

On the action tool

• select Update value
• Select File
• Replace specific String and provide the new path

using Alteryx Designer X64, Version: 2022.3.1.395

What am I missing?

Thank You

[FinnCharlton · Accepted solution]

Hi @MarkBurns ,

The radio button only returns True or False, so the way you have it set up at the moment it will be replacing the filepath with True or False.

Try using "Update Value with Formula" and a formula like this: 

If the button is selected, it will replace the "ThisYr" with "2022-2023". Hope this helps!

[MarkBurns]

@FinnCharlton Thank you.

This really helped,  updated the flow and it works a treat.

Makes sense that the radio button is true/false which is  attach to a formula.