Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Best Practices using tMelissaData component

 

URLhttp://wiki.melissadata.com/index.php?title=Result_Codes

 

we have result Codes for Melissa and Description for every codes in detail

After validating the given source of addresses through Melissa data component

The data is Loaded to staging if the result code column has 'AS01' otherwise we will be sending it to Stewards to take a look at the data.

We have column RESULTS_CODE , which will have codes. (Description for every codes in detail)

 

IN  RESULTS_CODE column you will find different codes like "AS", "AE" ,"AC""

 

For Data Stewards team

Please look at the data and column RESULTS_CODE where  you can find the codes to rectify the address

Priorities to rectify addresses (From the column RESULTS_CODE you will find different codes like "AS", "AE" ,"AC")

a)AE

b)AS

c)AC

 

With The melissa Data component we can leverage the codes and populate the clear message in the tables by using tmap expression, so it will help the business clearly , whether with which courier sevices the Address is deliverable, There are some address which has only usps deliverable and some address will be delivered by all courier services, and also we populate whether the address is occupied or not.

 

Please look below for tmap expression

0683p000009M38k.png0683p000009M38p.png0683p000009M38u.png

Labels (3)
1 Reply
scott3
Contributor II
Contributor II

It worked, great post!