ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now
The Alteryx Community will be temporarily unavailable for a time due to scheduled maintenance on Thursday, April 22nd. Please plan accordingly.

Location Data Knowledge Base

Data methodologies, and Release schedules.

ConsumerView Output Decoder Released



There are thousands of unique coded values in ConsumerView: 4,070 to be exact! It can be overwhelming to have to look them up. Fear not! The ConsumerView Output Decoder brings back the functionality of the ConsumerView Renaming Macro, but is now included with our data releases as of Q4 2019.

It decodes ConsumerView Field Values into readable values. No more will you have to search through a data dictionary to understand your data.



We listened to your feedback during development and the new tool can decode values from both the ConsumerView Household and Individual files with no configuration. The new version is over 6 times faster than the previous macro and will be updated every quarter with ConsumerView.

Using the Tool:

No configuration is required, simply drag it on to the canvas and connect your data stream with ConsumerView fields. The O output will contain the decoded value.


Be sure to use the ConsumerView Output Decoder at the very end of your analysis. Experian codes the values to reduce the size of the dataset and speed up processing. Using it early in a workflow will bloat the data in the workflow and slow down processing.

The tool is powered by the Dynamic Replace tool and the cv_key_value.yxdb in the Supporting_Macros folder relative to the macro. Dynamic Replace will return null if a value is in a field that is decoded, but not in the data stream of the R anchor. Be sure to only use this on unmodified ConsumerView fields.

6 - Meteoroid

Hi @JeffVR , 

Thank you for the update.  I installed the data package recently, and I can find the ConsumerView Matching macro on the tool bar (screen shot below).  However, I can't find ConsumerView Output Decoder as a tool anywhere on the tool bar, though it is within the data package Experian CV Analytical file --> Household --> Macros. Would you please provide additional instructions as how to drag the new tool on to the canvas?  Thanks!





Hello @YZhe!


The Output Decoder can be found in under the Calgary set of tools. It has a long name, so part of the name is obscured. It should be installed along with the Matching Macro with the household file. If you cannot find it, please let us know!




10 - Fireball

This is a great tool! Thanks for providing it. I used to do it the hard way, which was fragile. I would love to see it have the Mosaic segment names translated. I posted an Idea to that effect at