Alteryx Designer Desktop Ideas

Currently it's not possible to "switch off" interface tools in the same was as we can with the other tools. This limits the functionality especially within chained apps. If we could switch these tools off it would be much easier for us to tailor the experience by allowing selections to be activated by logic, rather than simply the data therein.

Please Alteryx Gods. I beseech thee!

*lights candles*

Here's a sample of what you get if no records are read into a python tool:

Error: CReW SHA256 (4): Tool #1: Traceback (most recent call last):
  File "D:\Engine_10804_3513901e8d4d4ab48a13c314a18fd1f9_\2f1b1eb4701e445775092128efe77f76\workbook.py", line 7, in <module>
    df = Alteryx.read('#1')
  File "C:\Program Files\Alteryx\bin\Miniconda3\envs\DesignerBaseTools_venv\lib\site-packages\ayx\export.py", line 35, in read
    return _CachedData_(debug=debug).read(incoming_connection_name, **kwargs)
  File "C:\Program Files\Alteryx\bin\Miniconda3\envs\DesignerBaseTools_venv\lib\site-packages\ayx\CachedData.py", line 306, in read
    data = db.getData()
  File "C:\Program Files\Alteryx\bin\Miniconda3\envs\DesignerBaseTools_venv\lib\site-packages\ayx\Datafiles.py", line 500, in getData
    data = self.connection.read_nparrays()
RuntimeError: DataWrap2WrigleyDb::GoRecord: Attempt to seek past the end of the file

I've fixed this in my macro by forcing a DUMMY record into the python tool (deleting it on the back-end).  It would be much nicer to have error handling that prevents the issue.  Even as a configuration option, what to do with no input this would simplify things.  

This error condition potentially effects every python tool created.

Cheers,

Mark

Similar to the setting that you have in many individual tools  (join, append, select, et al) where you can go to options and choose to "forget missing fields" it would be nice where you could go to options for the entire flow and "forget missing fields".

This would remove the headache that you have with large flows where you make a change(s) then have to go back through each and every tool to "forget" within that tool. Yes you could still do it individually, but if you chose, you could also do it universally for the entire flow all at once to all the 'missing fields'. 

Hi all,
Something really interesting I found - and never knew about, is there are actually in-DB predictive tools. You can find these by having a connect-indb tool on the canvas and dragging on one of the many predictive tools.

For instance:
boosted model dragged on empty campus:

Boosted model tool deleted, connect in-db tool added to the canvas:

Boosted Model dragged onto the canvas the exact same:

This is awesome! I have no idea how these tools work, I have only just found out they are a thing. Are we able to unhide these? I actually thought I had fallen into an Alteryx Designer bug, however it appears to be much more of a feature.

Sadly these tools are currently not searchable for, and do not show up under the in-DB section. However, I believe these need to be more accessible and well documented for users to find.

Cheers,
TheOC

Hello Team,

When we do run and cache workflow it remain in the cache memory for only the time the Alteryx designer or that workflow is open.

Advantage: We dont need to wait for the data to load in input data tool and the result is validated properly.

Disadvantage: Loss of time and money when the Alteryx Designer is closed automatically or mistaken.

Expectation:

Can we provide a token Expiry for 12 to 24 hrs so the precious time and money is not wasted.

This will be very useful when we are working on billions of Data.

Hello!

Currently when using the formula tool, you can create a string using the two following methods:

With speech marks, or an apostrophe being used respectively.

I would expect both of these methods to behave the exact same way, however what is interesting is that if you type within the apostrophes anything that would prompt a formula, this is still prompted:

This is not the case within the speech marks:

This can cause mistakes with autocompletion when typing within the field. I propose a small QoL change that the formula tool will recognise a string is being written when within two apostrophes. I believe the logic is already built for that, given that it behaves in every other way the same, and highlights green too. 

Cheers,
TheOC

Data Cleansing Tool:   There should be a sub-category on the "Punctuation" cleansing.  Ideally to have an option to "Include Only" or conversely "Exclude these characters" which would allow you for example to remove all characters except   "." from a dollar formatted field .  There are times when you need to clean almost everything except a certain punctuation or not. 

Hello,

More and more databases have complex data types such as array, struct or map. This would be nice if we could use it on Alteryx as input, as internal and as output, with calculations available on it.

https://cwiki.apache.org/confluence/display/hive/languagemanual+types#LanguageManualTypes-ComplexTyp...

Best regards,

Simon

By default output always print Headers as shown in item 1 below, I am looking to print item 2 as Header.  Item 3 is my output.

I tried item 4 below, doesn’t work.

Please consider this in your future releases.  It saves lot of time as the Outputs can contain hundreds of fields and output files are shared with User community who understands the Field description much more than Field name.  For example SAP Field-KUNNR does not mean nothing to a User than its description 'Customer'.

A check box on the Output Tool should able to toggle the selection between Field or its Description.

You might argue that the Rename column can be used, agree it would be difficult to manually type in hundreds of fields.  As an alternative you can provide automatic Rename population with Description.

Hello,

My issue is very easy to solve. I want to use the generic ODBC in memo for a specific base (monetdb here but it isn't important).

I try to ouput a flow in a MonetDB SQL database. As you can see, I only take very simple field types

However I get this error message :

Error: Output Data (3): Error creating table "exemplecomparetable.toto": [MonetDB][ODBC Driver 11.44.0][MONETDB_SAU]Type (datetime) unknown in: "create  table "exemplecomparetable"."toto" ("ID" int,"Libellé" char(50),"Date d"
syntax error in: ""Prix""
CREATE  TABLE "exemplecomparetable"."toto" ("ID" int,"Libellé" char(50),"Date de Maj" datetime,"Prix" float,"PMP" float)

Reminder : SQL is an ISO Norm. Default type should follow it, not the MS SQL configuration. Interoperability is key

Links to : for in-db
https://community.alteryx.com/t5/Alteryx-Designer-Ideas/Generic-In-database-connection-please-stop-i...

Issues constated : MonetDB
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Output-Data-date-is-now-datetime-makin...

Informix: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Alteryx-date-data-type-error-trying-to...


Best regards,

Simon

It'll be great to have different icons whether Designer is executed Elevated or not, so it's easy to identify the instance you need to work with.

I test the  10% percentile for {1,2,3,4,5,6,7,8,9}, whch alteryx gives 1.8, while it should be 1.
According the help, it should return the value of the target row, which shall not result any decimal in this case.

This is Ganesh from Guidelines. 

One of the task in my process is to convert the Pdf to excel sheet for all content. 

Pdf content will all depend upon the number details available. 

Pdf contain table format detail. 

We would like see all the pages of pdf should be in excel sheet with proper format including Table provided in pdf.  

I tried multiple ways but unable to find easiest way of handing the auto fit the all the column in final output. If we have already could you please help me with the solution. 

if not - can we create one additional tool which auto fit and align the data type accordingly. 

2 issue is about post I bifurcate the excel sheet data with multiple workbook data type doesn't show proper. for example Main file contain string and numeric value. post the bifurcate all the number still shows string value only due to every cell has green tick mark. 

Need an option in the output tool(Delete and append option is selected) so that if some error occur while writing into the table. workflow would automatically gets back to original record count. Right now if the workflow fails we are seeing zero records in the output table.

Hi 

Sometimes when your using a filter you want to let everything pass through. Which means you have to remove the filter or go around it.

In stead of beeing able to out comment your filter. And the filter tool see's that as no filter.

Hi 

I'm really missing a search in the medata phane?

If I am on data phane:

If im browsing though metadata:

Hi 

In a toold like select it would be nice to place curser in Field - and type the first letter of the fields you want to browse through.:
By pressing F here I would just across fields that starts with F.

Sometimes you want to preserve the field order from the sorce, and if you have many fields it takes a while.

Or beeing able to filter - just like in excel:

Same goes for formula box:

Beeing able to click D as an example and click though coloumns starting with D.

Note: This idea doesn't strictly fit into any given category as it involves enabling support for something that affects numerous aspects of Alteryx's already existing spatial features.

I live in Australia. As do a large number of your users. Like me, many of those users use Alteryx to process spatial data. There is only one problem; we live on a roving continent. Every year our continent shifts ever so slightly but over time that shift becomes significant. For this reason we have our own continental system of spatial coordinate projections. It's called the Geocentric Datum of Australia or GDA.

Since 2000, the official Australian geodetic datum has been GDA94.  However, according to the Intergovernmental Committee on Surveying and Mapping (ICSM), because the coordinates of features on our maps, such as roads, buildings and property boundaries (and so on), are all based on GDA94, they do not change over time. This is why they have since adopted a new datum: GDA2020. This has now become the standard for mapping in Australia, bringing Australia’s national coordinates into line with global satellite positioning systems.

A more detailed explanation of this can be found on the ICSM's website: What is changing and why? | Intergovernmental Committee on Surveying and Mapping (icsm.gov.au).

Of course Alteryx supports the more global WGS84 standard, which like GDA94 is a fixed datum. But there is up to a 1.8 metre discrepancy between GDA94 (and WGS84) and GDA2020. For spatial analysis projects that don't require metre accuracy that's not a problem. But imagine you are building a bridge, plotting the lanes of a road or programming a GPS enabled tractor. That 1.8 metre discrepancy between the real world coordinates and the projection is enough to cause problems. 

And it is. Which is why we request that Alteryx include support for GDA2020 in its existing selection of spatial projections.

This will enable spatial datasets configured in GDA2020 to not require conversion and thus risk corruption or error. This includes providing the ability to configure GDA2020 as the spatial projection in the input tool and all spatial tools.

Doing so would go a long way to supporting your ever growing Australian user base and maintaining Alteryx's position as a trusted software for processing spatial data.