Alteryx Designer Desktop Ideas

My organization is considering a move to a Microsoft Azure platform but requires support for Bring your Own Encryption (BYOE) or Bring Your Own Key (BYOK). As such, leveraging alteryx on this data lake would require this level of support.

 

I would like to see Alteryx support this in the future, ensuring that we are able to leverage the power of alteryx designer within this platform.

We use several Files that are fairly large (canvas size). To traverse around to try and find where we last left off or to examine a specific X, Y at a specific zoom....one would need to either remember the tool number to search for or search for a keyword that returns several choices.

 

My suggested solution would be to create a bookmark(s). This would allow you to save a named bookmark that would save exactly where (X,Y) you are in the canvas and the Zoom level (Z). This way you could easily switch back and forth with in a canvas just back clicking the bookmark.

 

If anyone has ever used a CAD program that allowed the creation of 'Views' within the same diagram...this would be similar.

 

Thank you

Hi,

 

I've been working on reporting for a while now and figure out that creatitng sub total wasn't part of any tool. 

 

Any chance this could be implemented in next versions or any macro available?

 

Thanks

Simon

 

As you may be aware localisation is the adapting of computer software to regional differences of a target market, Internationalization is the process of designing software so that it can potentially be adapted to various languages without engineering changes.

 

The idea is to make Alteryx designer tool, the web help content and example workflows to be multilingual (Possibly with the use of "lic" language files or similar) Hopefully the sotware and tutorials will all be localised by crowdsourcing initiatives within the Alteryx community. 

 

I sincerely believe this will help the tool get a lot of traction not in US and UK but in other parts of the world,

Highly likely Mandarin and Spanish would be the first two language versions...

 

Top languages by population per Nationalencyklopedin 2007 (2010)Language Native speakers(millions) Fraction of worldpopulation (2007)

Mandarin	935 (955)	14.1%
Spanish	390 (405)	5.85%
English	365 (360)	5.52%
Hindi	295 (310)[2]	4.46%
Arabic	280 (295)	4.43%
Portuguese	205 (215)	3.08%
Bengali	200 (205)	3.05%
Russian	160 (155)	2.42%
Japanese	125 (125)	1.92%
Punjabi	95 (100)	1.44%

Please test/certify Teradata 16.2 for designer, server, scheduler, and Gallery applications.  

I would love to see a multi-output filter for cases where I want to route records to different places for processing based on the value of a single field. 

 

For example I want to filter each letter to a different destination:

Letter	Number
A	1
B	1
C	1
D	1
E	1
F	1
A	2
B	2
C	2
D	2
E	2
F	2

 

I would love to see a single tool that can send each letter to a different destination. See the attached screenshot for a concept of what this could look like. 

In v10, I am using the summarize tool a lot and getting tired of selecting one or more fields and doing a sum function and having to revisit each summary tool when you add a numeric field upstream... I was hoping there would be a more dynamic method, e.g. select all numeric fields and then doing a SUM on _currentfield_.

Then I remembered the Field Info tool. (on a side note, I'd bet this tool is overlooked a lot). This tool is great because for each numeric field you get Min, Max, Median, Std Dev, Percent Missing, Unique Values, Mean, etc.

The one thing that's missing is SUM. Can you add it?

 

Also, can you give the user option to turn off layouts and reports so it runs faster? I only care out the data side.

 

or is there another way to do sum on dynamically selected numeric fields? (include Sum on Unknown field)

It would be great to have a spatial function that could be used to evaluate whether two spatial objects are equal/identical. I see this being available in at least three places:

 

1. An "ST_Equal" Formula function
2. A SpatialMatch "Where Target Equals Universe"
3. An "Equals" Action in the Spatial Process tool

After the upgrade to Alteryx 2018.4, the publish to tableau server tool no longer has the feature to get the authorization header to make subsequent calls in the workflow.This feature was present in the older versions of the tool i.e Publish to tableau server 1.09,1.08.1 but not in the new version 2.0.0

I think this feature should be present in all the versions of the publish to tableau server tool.

 

Cheers

The challenge:

We have hundreds of SOAP based Salesforce (SF) connectors in our scheduled modules that were created with Alteryx 9.0-9.5. Alteryx 10.0+ is now using REST API based SF connectors. We have to replace all of these connectors when we move to 10.0+.

 

Proposed idea:

Alteryx creates an automated process for converting SOAP SF connectors to REST API SF connectors, so that when you open an old module in 10.0+, they are automatically updated.

 

This seems feasible as the information supplied by Alteryx users for the SOAP SF connectors is sufficient for the REST API SF connectors to work (i.e. URL, username, password, security token, table name, fields, WHERE clause, etc...).

 

Thanks,

Jeremy

If you have a field length of say 10 in a Select Tool, then you use a Left Join tool and change that length to say 4. This turns that field red - as it should.  Then add a Select tool after the Union.  It should say 4 in the second Select tool.  But instead it says 10.  If it was changed to 10 (and it wasn't) then the field s/b red.

It would be great if we could change the name of a variable upstream it follows through in formulae etc.

I haven't needed to do this for over a year, but I just tried in 2018.4 and the functionality is not there any more 😞 

 

I'm trying to open an Excel file and customise the SQL used to read the data.

 

I've found this in other posts:

 

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-do-I-get-row-range-in-Excel-format...

 

then I found this one 😞 

 

https://community.alteryx.com/t5/Alteryx-Designer-Ideas/Input-Tool-2018-1-Excel-Range-Feature-Remove...

 

Hopefully this feature will be re-instated soon 🙂

Hello!

 

There this very handy functionality in Alteryx that when you drag files from a Windows explorer onto the Canvas, the tools automatically convert to Input Tools. When making Alteryx smaller using this  - button, the canvas gets minimalized to nothing. This means I cannot drag files onto the canvas. The suggestion is to always keep a little bit of canvas space here to drop files onto. Just another small QoL issue. 

 

 

 

Cheers,

Marco 

Our company deals a lot in .dif, .kat, and .px7 files for importing into our softwares. Would it be possible to add these additional output types since it would save the additional step of re-saving the Excel file as a .dif.

Hi,

I have a large dataset (~200k) of routers with the utilisation figures per month over 36 months. What I have been doing till now is using the TS Model Factory to config and TS Forecast Factory to generate the forecast for the next 6 months grouping by router. Great! Except the values returned per device are exactly the same for the next 6 months. Obviously by not using the ETS / ARIMA macros I lose the ability to configure in more detail.

What I would like is be able to set the parameters of the ETS/ARIMA model in advance then run the batch macro for the number of routers and return a 6 month forecast that takes into account all the parameters.

Happy to supply data if required!

Thanks in advance

Mark

It's been a while since I was last on these forums, and I can't find the suggestions subforum, only one massive 'Designer' forum. Hopefully I'm posting this in the correct place.

 

Anyway, the font colour on my Basic filter dialog dropdowns is for some reason bizarrely light and difficult to read. How do I fix this? It used to be a black font, so I'm trying to figure out what I've done wrong. It needs to be darker. Thanks

 

Hello Alteryx Community,

 

I've recently started using Alteryx and one option on the Output Data tool I think that could be useful to others and myself is the option to choose: Append to an extract file (Create if does not exist). This is similar to the already existing Overwrite existing extract file (Create if does not exist) option.

 

My case for this is... I'm in the situation where I'm setting up a flow that I know from the offset is going to be a repeatable flow that is designed to build up data over time and so I will be running the Output Data tools in append mode. Except for the first run, I can't append to an extract that doesn't exist! The flow in question has over around 20 Output Data tools and while it wouldn't take terribly long to reconfigure after the initial run, it is a bit tedious. I think there is scope for my proposed option for being implemented either as a standalone option or to replace the current append option.

 

Example of my current flow:

When a tool's input connector is already attached to a data stream that only accepts a single connection, attempting to attach a 2nd data stream with the same fields should automatically insert a Union tool.  This would be similar to the way an Action tool is automatically added when you connect an Interface tool to another tool.