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.
Have you ever used the Allocate tools and received back some strange looking variable names? You're not alone! The Allocate Rename Fields Macro will allow you to rename your fields into readable variables.
We have identified an issue with the Consumer Expenditure variables defined in the VVF files installed with the Q2 2021 Experian US Allocate dataset, specifically Current Year Estimates (2021) - Total Expenditure (TCTOTALEXP) and Five-Year Estimates (2026) – Total Expenditure (TFTOTALEXP).
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.
This article focuses on one key area of our Location Insights products – Maps. I'll use the US Location Insight product for this example, but all of our international Location Insight products are functionally the same unless I call it out specifically as a unique part of the US package.
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?
I have CAPE installed and a newer version of a VGF (with updated names) is available in a new install. I uninstalled that version of the data, ran the new install but the old VGF names are still visible. I reran the install twice. What am I doing incorrectly? I notice when I run the install, the process happening more quickly than usual.