2022.1.1.30569 Patch Release Update

The 2022.1.1.30569 Patch/Minor release has been removed from the Download Portal due to a missing signature in some of the included files. This causes the files to not be recognized as valid files provided by Alteryx and might trigger warning messages by some 3rd party programs. If you installed the 2022.1.1.30569 release, we recommend that you reinstall the patch.

Alteryx Designer Ideas

Share your Designer product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

Maintain references in Excel files when using file browse tool

When building out Alteryx workflows there may be a need to read in different ranges within the same Excel spreadsheet. For example bringing in a table from Sheet1, but also isolating a table name in a particular cell (in my example cell C8).

 

cgoodman3_0-1651072926555.png

 

When turning this into an analytic app, with a file browse is to add an action tool with the default value of "Update Input Data Tool".

cgoodman3_1-1651073022944.png

 

However when specifying this option within the analytic app interface, you are only allowed to chose one option of the following:

i) Select a sheet

ii) Select a sheet and specify a range

iii) a named range or

iv) a list of sheet names.

 

The problem is in the example above I need a sheet and a range, but I want to avoid adding two file browse interface tools as it shouldn't be needed. If the user selects (i) then it loses the reference to cell C8, but I would imagine a lot of users as they get started with apps don't realise this is what will happen.

 

There is however a way to solve this currently and it requires overwriting the default behaviour and configuring the second action tool (the one that updates the file for C8), to update value with a formula, where you assume the user would select sheet name and then use this formula:

 

replace([#1],"$`","$C8:C8`")

 

However I would argue that this has a lot of technical debt, plus if the user needs to modify where the header is, for example to D8 they need to change the input file and the action tool so it works as a workflow and an analytic app.

 

Solution

Like how the configuration options for the input file, such as which row to input data from or whether first row contains data is maintained, modify the behaviour of the default option in the action tool to maintain references to ranges.

 

 

4 Comments
patrick_digan
17 - Castor
17 - Castor

Great Idea! 

Aguisande
14 - Magnetar
14 - Magnetar

Agree! Great Idea that will make users life easy

fmvizcaino
16 - Nebula
16 - Nebula

Hopefully, this gets accepted. I really like the idea of simplifying analytical app development.

Shifty
12 - Quasar

Yes!  This is a really good idea. Fingers crossed for this one.