Alteryx Designer Desktop Ideas

SQL and Tableau both support a CASE function with the syntax

CASE

  WHEN Condition 1 THEN Result 1

  WHEN Condition 2 THEN Result 2 ...

  WHEN Condition N THEN Result N

ELSE Default Result

END

 

I'm thrilled that I can now use this with the In-DB tools, but I'd love to have this available in the regular function tools so I can stop nesting my IFs!

 

It would be helpful to have one of the following methods to disable output modules to prevent overwriting output files each time a workflow is run:

- A global 'Disable All Output Modules' option, which would effectively mute the workflow without removing any connections

- A module-specific 'disable/enable this module' option, to the same end

Hi,

 

I've been using desktop scheduler to download and parse out a streaming JSON file.  My script takes 4 seconds to execute, the data is updated on a per second basis.

 

Currently, my only option is to execute the scheduled job at the lowest level of granularity in the temporal at 1 minute. therefore I'm missing records.

 

Would it be possible to add a second(s) option to the scheduler?

 

I can see particular benefits from doing a CRON at under a minute, especially with event data capture.

 

Best Regards,

 

Allan 

Would be nice if could use something like $Field rather than repeating the field name in the Condition and Loop expression within the Generate Rows tool

 

 

When you do a search for a tool, don't zoom to a blank area of the canvas (because that's where the tool would have been with an enabled container). So when a container is disabled, zoom to the actual container instead containing the tool you're looking for or temporarily enable the container so we can see the tool?

It would be great if I could save a tool and its configuration for future use. I'm sure this could be done now with a macro, and that's possibly how I'll do it.

 

The scenario is that we have numerous data inputs that require some finessing to import. Because the field headers are not in the first row, they aren't recognized accurately as comma delimited. But some of our fields also contain commas within the field, so the solution is to add a multi-field formula to replace things like ", Inc." with " Inc." and ", Ltd." with " Ltd."

 

But on occasion I find new text strings that need to be added to the formula, like ", Inc" (without the period) for instance.

 

I use this replacement technique with several workflows, so it would be great to change it just one time and have the other instances updated automatically.

 

Maybe in addition to our Favorites toolbar we could have a Custom or User toolbar where we could save tools along with their configuration.

I recently had an error in a module because an expected variable was not present coming into a formula tool.  My variable, "MONDAY" was not present and the formula MONDAY/3 failed.  The workaround was to union all days into the incoming data and things worked fine.  I would have liked to have an Excel formula like this instead:

 

IF ISERROR([Monday]/3) THEN 0 ELSE [Monday]/3 ENDIF

 

Thanks

Maybe it was a lack of planning, but I've had a need to rename a variable within a workflow and would like to (outside of the XML view) be able to rename the variable so that downstream tools don't have to be reconfigured (e.g. formula, join, union).  

Adding sort option to the browser output windows would aid in troubleshooting and in understanding the data at that specific point in the stream better