Alteryx Designer Desktop Ideas

Love the functionality to create filters on the Calgary database but it would be nice to be able to select the columns you wanted returned. There are times where you only want a couple columns but the input tool will return all columns creating a larger dataset then required. You can add a select right after the input but this is after the entire dataset has been loaded into memory. Combining the two would make the Calgary input tool behave more like a database then a standard "dumb" input source. 

It would be nice if we could resize the linked calgary tables box in the calgary input tool. It only shows 2 tables by default. I would like to be able to show more at times. I can change the size of the fields and query boxes, but the linked tables box is fixed at 2 rows by default.

 

It would be very helpful if we could pick from a list of installed calgary datasets in the dropdown menu:

we currently have the ability to choose geocoder/drivetime/Allocate datasets which are typically stored in the .ini files, but don't currently have the ability to choose calgary datasets. 

 

 

As with Output Data tool, it would be very helpful to have this option within the Calgary Loader tool.  I have a series of ordered analytic apps and if I could name the Calgary database using the "Take File/Table Name from Field" option I would be able to chain the apps and be much more efficient.

 

Thanks.

I would like to be able to add an in-house built Calgary db to the list of data sources in the pull down on the Calgary Input tool. A customer database, for example.

 

In the picture you can see the Kalibrate Technologies Traffic Counts and TomTom US Address Points in the pull down. I would like to add my own Calgary db to the list of choices.

 

Functionality to append to Calgary Databases.  Currently we are unioning Calgary Database to another dataset and overwriting existing Calgary database.  Ability to append would cut down on data processing.

In my environment, installing Core Data Bundle to network drive ("prepare a network install") runs for hours or days due to network factors. If interrupted, I need to start from scratch again.

 

These changes would greatly improve the installation:

1. Maintain verbose installer log to track progress and confirm that all selected files are successfully installed.
2. Add a repair mode to the installer to repair interrupted installations. When run in this mode, only missing/corrupt data files will be re-installed as necessary (much faster than fresh install).
3. Support use of a shortcut like "CURRENT" on my network drive to the real installation directory (say "Q3_2017"). This would allow me to point to the latest release and users who "register from a network location" via "CURRENT" shortcut path will always get the latest data files. As an administrator, I have no way to know if my Alteryx users are configured to use an obsolete data set that I want to clean up from my network drive.
4. When I prepare a network installation, I'd like to specify an expiry date and warning message that users will see in their workflows if they access obsolete data sets. Example: "Core data set XXX is obsolete as of 12/31/2017. Register current version via \\my-network-drive\alteryx\???\DataInstall.exe...". Nice to have would be a warning date and an error date to provide grace period. This would be similar to the CASS data set expiry date.

When choosing "In List" values in a CYDB input, the normal Windows functions do not work (shift+click, ctl+A, ctl+click, etc.).

 

When having to choose, say, 20 values, it is a big annoyance to have to click each value (20 clicks). 

 

Have been told this is a bug so I wanted to put it on your radar for a fix.

Could we please have the option of selecting the fields, like the join tool, within the Calgary Join tool?  It is especially problematic when I simply want to assign spatial object name to a point; i.e customers within a DMA or sales territory.

 

This would be agreat addition within the ConsumeView Matching tool as well.

 

  Thanks!

A quite basic request but still really frustrating when working with this component.

Can you please allow the resizing of the window in the List for Calgary input tool ? 

 

Please see an example attached. 

As a GIS department, we use numerous spatial datasets on a daily basis.  Many of these are quite large and we are looking for ways to optimize their performance.  Right now, we are forced to use an indexed folder system to increase performance, but we would like to move to Calgary databases.  The problem is, that Calgary databases only hold point features which limits the number of our datasets that we can use it with.  If we could spatially index line and polygon features as well, that would dramatically increase the usefulness of a Calgary database.

When workig on a module with many tools, and one of those tools is the Allocate Input tool (Experian US), whenever you try to access or configure that other tools, there is a delayed reponse.  I'm assuming because the Allocate data set is so large.  But, it would be nice, if possible, that when accessing/configuring other tools you did not get that delay.  My workaround is to Container the Allocate tool and disable it.  

Calgary CrossCount returns 1 row for every permutation and combination of possible crosscounts for the given crosscount fields.  This idea is to use the additional query criteria to limit the output of rows.

Example:  State Code = 'MI' and Mosaic Type = 'A01'  could be our Criteria.  and State Code, Mosaic Type and Gender would be our crosscount fields.

Calgary crosscount (and append) would output (51 * 71 * 4) 14,484 rows (all states * all mosaic types * all gender values)

The desired crosscount would output (1 * 1 * 4) 4 rows (MI * A01 * 4).

This is a simplified example just to demonstrate my confusion when Alteryx responded to me that the tool is working as designed.  In order to reduce the crosscount output, you must restate your query criteria in a filter post the calgary tool.  If the count of rows output exceeds a thresshold, you can't even use the tool as it will generate too many rows.

By defining criteria in the Calgary Input tool, only the desired output records are generated.  But by defining criteria in the Calgary crosscount tools, only the desired "combinations" have values plus it outputs all permutations and combinations of other non-qualifying records.

Please consider this request for an enhancement.

Thanks,

Mark

Our team works with a lot of in-house transaction data sets that have been put into a calgary database.  It would be much easier to build apps that use the calgary input tool without having to configure html code.

I have not found this function or a workaround, only as "recent connections" which normally, are not saved on Virtual Machines.

This would save the time it takes to find the path/folder where Calgary DBs are saved.

 

if this has been proposed or fixed already, please delete this idea! 

Would it be possible to have Calgary index files saved to a sub folder so they don't reside in the same folder where the cydb is located? All these indices just clutter up the folder. Thanks,

Simon

It would be helpful to have a unique feature within Calgary in order to return a unique count or a data extract. The current Crss count will error if there are two many rows.

Please have the Calgary Tools put the file names in the annotation automatically like all other input/output tools. 

I love the new (relatively) ConsumerView Decoder Tool! I used to do it the hard way, and it was fragile.

 

However, one thing is still missing: the Mosaic fields (MOSAIC HOUSEHOLD and MOSAIC ZIP4) - these are output from the tool as nulls. So, not only do you not get it decoded, you have to join back to the input to get the fields back as they were.

 

First, at least please pass them through as they were.

 

But preferably, decode them to the Mosaic Segment/Group names.

 

I realize (or couldn't find) the source for the Mosaic segment definitions is not currently in a Calgary database, but the tool is in the Calgary group.