This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
The Q3 2021 Business and Location Insights data packages are now available to plug into your analytic processes. The packages include analytics-ready data from a variety of vendors as well as data-specific analysis tools which will empower users to get the most from the packaged data.
The Data Products team has identified the deprecated field CASS_StatusCode included in the US and Canada Dun & Bradstreet Analytical File. This field will be removed for the Q3 2021 Business and Location Insights release since the field had been replaced with CASS_ErrorCode long ago. We are making this post to notify any users currently running workflows referencing CASS_StatusCode so they can adjust their workflows before this update.
Have some Latitude/Longitude points and not much else? Working with Spatial Objects and need more information than a simple map point? Time to call in the Reverse Geocoding macro. Reverse Geocoding can give some robust information to help make important business decisions when working with spatial data. Case in point: Your “friend” has hacked the Pokémon Go APK and hands you a list of Pokémon with the associated Latitude/Longitude. You can’t make an informed decision on your next weekend Poke-session without first understanding more than just the location on a map!
Occasionally someone asks the question, “how many businesses have ACTUAL YEAR STARTED” (or referenced another field) and you have no idea how to respond. You looked in the quarterly Variable List and didn’t see the answer. Now what? You could run a query in Alteryx but should you?
The Q2 2019 Business and Location Insights data packages are now available for analysis. The packages include analytics-ready data from a variety of vendors as well as data-specific analysis tools which will empower users to get the most from the packaged data.
The option to be able to search a field with wildcard characters is often needed. This functionality within the Calgary suite of Tools can be accomplished by having a “Contains” function, where this is accomplished without utilizing a wildcard to search. This also allows you to be able to use the Indexing power that the Calgary products offer, without having to do these searches with downstream functions like Filter or other Formula based tools. Tools used: Here's how 1) Create a base cydb file with this option selected: 2) Once the base file has been created, you now want to modify that cydb file to enable the Fields you want to query with the “Contains” option. In this example dataset, we want to be able to do these type of queries for the “CONAME” and “ADDR” fields: Setup Calgary Input into Calgary Loader, when the following message will appear. Make sure you check “Yes” 3) Select the “Load a single advanced index” option Set the Index Name you would like (in this case, keeping the same name), and choose the field desired from the “Source Field”. Also, set Advanced Index Mode to Full Text 4) Repeat this process with all of the fields you’d like to be able to search. In this sample, placing “mail” in the CONAME and “ln” in the ADDR fields returned this record:
The US and CA Data and Spatial Bundles contains many datasets, including the Melissa Data CASS engine. While the US and CA Data Bundles are updated every quarter, CASS is updated every 2 months. Luckily, the install file size for CASS is just over 1gb, so we are able to provide this update as a download. Once downloaded, a few simple steps will get you on your way to using the most updated version of CASS. On occasion though, users have reported a few issues with being unable to utilize CASS. Because of this, we have decided to provide full download and install instructions, with a final portion of frequent questions and issues. To install the latest CASS:
Download the latest version of CASS. This is sent via email from Alteryx Products on a bi-monthly basis and will be in the format of the following:
YY is the current year and MM is the current month release of CASS.
Double-click on the .exe file. This starts the 7-Zip Self-Extractor. Choose a location where you would like to extract the install files.
IMPORTANT: This does not actually install the files, it only extracts the install files.
Once the install files have been extracted, located and double-click the file DataInstall.exe. This will be in the directory you just extracted to in the previous step.
When the install dialogue pops up, check the box to accept the license agreement and click Next.
The next screen allows you to select datasets to install. Depending on which install you've chosen, you will see the option to install US, Canada, or both versions of CASS. Check all boxes, then click Next.
This screen displays all current datasets installed on your machine. Checking any box here will uninstall the dataset. By default, the previous version of CASS will be checked for uninstall. Make sure all prior versions of CASS are checked, then click Next.
IMPORTANT: You must uninstall all previous versions of CASS during this process. If you have any expired versions of CASS on your local machine, no other versions of CASS will work properly.
Browse to the directory you wish to install CASS to, then click Finish.
Once the above steps have been completed, you will be able to use CASS on your local machine. FAQ/Common Errors:
Error: CASS (2): CASS is not installed properly or it has expired. Please contact your reseller or Client Services at 1-866-516-2400 1-866-516-2400 FREE to receive an updated CASS database.
This is often because a prior version of CASS is still installed. Re-run DataInstall.exe and make sure all prior versions of CASS are checked in the Uninstall screen.
CASS was installed on a network drive and permissions are not allowing you to see it. Try re-running DataInstall.exe and install CASS on a local drive.
Error: CASS (1): The Melissa Data CASS engine appears to not be installed (can't find dll).
This is often the result of mismatched registry entries or install folders. Please contact firstname.lastname@example.org for resolution.
In most cases, the solutions for error 1 above will resolve your issue, but if not please don't hesitate to reach out to email@example.com for handling. Thanks, and until next time! Chad Follow me on Twitter! @AlteryxChad
If you need more geographical information on a coordinate, try converting it into a spatial object and using the Find Nearest Tool to find coinciding Experian geographical data from an Allocate Input Tool.