community
cancel
Showing results for 
Search instead for 
Did you mean: 

alteryx connect Ideas

Share your Connect product ideas - we're listening!

1 Review

Our submission guidelines & status definitions before getting started

2 Search

The community for a solution or existing idea before posting

3 Vote

By clicking the star in the top left corner of an idea you support

4 Submit

A new idea to suggest a product enhancement or new feature


Suggest an idea

Connect applies a standard set of weightings to different categories of information (people, terms etc.) when returning search results. When combined with likes/dislikes, these determine the order in which results are returned - details below:

 

Alteryx Connect uses the following scoring parameters for the Lucene engine:

  • Likes and Dislikes, using the following formula: (Number of Likes) / (Number of Likes + Number of Dislikes).
  • Certified assets: +1.2
  • Person: +2.4
  • Term: +2.2
  • Report: +2
  • Report sheet: +1.8
  • Alteryx workflow: +1.5
  • Table: +1.4

 

It would be useful to have control over this weighting, e.g. when you have large numbers of Person records being returned before Terms; but advice from Customer Support has been that these are not currently customisable. I'd like to request that this ability be considered for inclusion in a future release of Connect.

 

 

  • Setup & Configuration

Connect currently provides lineage for a datasource at the table level but we would like to be able to have this at a more granular level i.e. the column level so if a specific column changes in the table (e.g. data type change), we are notified of the change and able to identify quickly assets that will be affected.

 

@SeanAdams @Revathi

0 Stars

for the past 8 months I have been using alteryx and mostly working with the connect in db components , there are many issues which I am facing and i this this can be improved 

1. there is no such  flexibility of creating a table with the keys defined which is the most important pillar in database, also the options provided are limited , i.e. to create a new table , delete and append, drop table and recreate, 

now, there are many times where in we  need to update the tables based on the keys, which i find missing. Also how the option is defined is create a new table, next time if the job is run it states that the table is already created, for which we need to manually change the option in the next run.

 

2.which switching between in db and alteryx , if the records are more the alteryx lags completely and the job keeps running for hours , how can we achieve the flexibility  of alteryx designer if there is such bottleneck.

 

3.the flexibility that is provided with alteryx designer should also be given to in db components.

4.the parameters defined in the workflow can not be accessed in the in db  formula tools but can be used in the designer formula tools. this reduces the flexibility.

 

please look into the same

0 Stars

quality-not-quantity-words-on-board_GJjTpNvd.jpg

 

When Alteryx connect is first installed to a company with a small alteryx designer base, you do not benefit from lineage.

There are not much workflows at hand. So in order to realize Alteryx connect's immediate benefits I'd like to suggest;

 

a company-wide Data Quality Score.

 

  1. Let's score each data element in distributed data stores
  2. And automatically give a simple scale between one and five
    • 1 equals to, “we don’t know”
    • 2 data is entered or updated prior to 1 year, has conflicting data
    • 3 would be the norm and means customer provided this data, as accurate and as up-to-date as they have entered it and ‘agreed’ to share with you.
    • 4 means we cross checked the data with 3rd party sources or the addresses work in Google Maps”.
    • 5 equals to “we had the customer or the representative validated the address in last 3 months”.
  3. The scale will be based on;
    • Missingness
    • Information value (variance is high or not, if there is no variance no info useful thru the column)
    • How many times that column is addressed in other tables
    • Format (structured like a telephone number ###-##-## or semi structured like an address)
    • Is it an ID column
    • Is it a Datetime column, any discrepancies in date time columns etc.
    • Time since last update of data
  4. Once we have some lineage information than we'll weight th data based on how frequently it's needed, how many formulas are requiring the field etc.

 

And as soon as we install connect we'll have a grand vision of our data and even we'll be able to track the status of our whole distributed data assets with a trend line if we are going better or worse... Here is an example;

Cy6-HzAXUAABOLs