Expand my Community achievements bar.

SOLVED

Table Joins not happening properly in Enrichment Box.

Avatar

Level 2

We are joining 2 tables in enrichment.

In Table 1, we have unique email-id as the only column.

In Transaction table we have Email-id, Amount & date columns.

i am joining it with transaction table which has multiple records for every email-id.

We have 15 records in the Table1 & the transaction table has 19 records. All the email ids of transaction table is present in table1.

However, on joining we are getting only 15 records instead of the expected 19 records. 

We tried joining it will all possible cardinalities. 1:1, 1:N, 1:0

Unable to understand where are we going wrong.

1 Accepted Solution

Avatar

Correct answer by
Employee

Hi sibyj2188 ,

It will be difficult to really comment why the two are not working without seeing the setup of Enrichment.

At present what I can suggest you is lets say table1 is the schema with email address fields and table2 is the transaction table.

My guess is that when using Enrichment, you have taken two query activities pulling in data from the two tables and trying to link them with help of Enrichment. Currently the primary set has been selected as table1.

Try reversing the condition. This time create a fresh Enrichment activity and disable the older one. In this new Enrichment activity select table2 to be the primary set and then create a link with table1. When selecting type of link make use of option 1:1

Output of this Enrichment can then be fed to a Change Dimension activity giving you table1 as the targeting dimension.

Hope this helps.

Regards,

Vipul

View solution in original post

1 Reply

Avatar

Correct answer by
Employee

Hi sibyj2188 ,

It will be difficult to really comment why the two are not working without seeing the setup of Enrichment.

At present what I can suggest you is lets say table1 is the schema with email address fields and table2 is the transaction table.

My guess is that when using Enrichment, you have taken two query activities pulling in data from the two tables and trying to link them with help of Enrichment. Currently the primary set has been selected as table1.

Try reversing the condition. This time create a fresh Enrichment activity and disable the older one. In this new Enrichment activity select table2 to be the primary set and then create a link with table1. When selecting type of link make use of option 1:1

Output of this Enrichment can then be fed to a Change Dimension activity giving you table1 as the targeting dimension.

Hope this helps.

Regards,

Vipul