Location Data Knowledge Base

Data methodologies, and Release schedules.

ConsumerView Output Decoder Released

JeffVR
Alteryx
Alteryx
Created

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.

ConsumerViewOutputDecoder_1.png

ConsumerViewOutputDecoder_2.png

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.


Considerations:

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.

No ratings
Comments
YZHE
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!

 

YZhe_0-1594149467357.png

 

JeffVR
Alteryx
Alteryx

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!

 

JeffVR_1-1594150601426.png

 

blyons
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 https://community.alteryx.com/t5/Alteryx-Designer-Ideas/Add-Mosaic-name-translation-to-ConsumerView-....

 

YZHE
6 - Meteoroid

@blyons 

I checked the link in your post above.  Actually the decoder did translate Mosaic fields (MOSAIC HOUSEHOLD and MOSAIC ZIP4) before.  Last time I used the ConsumerView Output Decoder, which was about 4 months ago, the two fields MOSAIC HOUSEHOLD and MOSAIC ZIP4 were still decoded and have some values.  

Today I tried again and found out the decoder output nulls for the two fields.  I believe we need to open a ticket with Alteryx support for the issue.

Thanks @blyons 

 

YZHE
6 - Meteoroid

@JeffVR  would you please review my comment and @blyons comment above.  See if you notice something differently regarding the MOSAIC HOUSEHOLD and MOSAIC ZIP4 from ConsumerView Output Decoder.

blyons
10 - Fireball

@YZHE Thank you for posting and reporting that! I had not seen a version that decoded the Mosaic fields. I opened the macro to look at its code, and there is nothing I could find in it that implies it ever existed.

JeffVR
Alteryx
Alteryx

Hello @YZHE and @blyons,

 

Our apologies, it does look there was an issue with the underlying yxdb supporting the macro in the Q4 2020 release and those fields were missing. I've identified the issue and it will be corrected in the Q1 2021 release.

 

As a workaround for the Q4 version in the meantime: If you have the Q3 version of the ConsumerView installer available you can find the database that supports the macro: 2020_Q3_ConsumerView\Experian_CV_Analytical_File_Q3_2020\Household\Macros\Supporting_Macros\cv_value_key.yxdb and replace the database where the macro is installed.

 

If you need any assistance with that, I've let our support team know about the issue and fix.

 

Thank you for bringing this to our attention!

 

 

blyons
10 - Fireball

Excellent. Thanks so much!