Table Joins not happening properly in Enrichment Box. | Community
Skip to main content
sibyj2188
sibyj2188
Level 2
December 22, 2016
Solved

Table Joins not happening properly in Enrichment Box.

  • December 22, 2016
  • 1 reply
  • 1546 views

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.

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by vraghav

    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

    1 reply

    vraghav
    Adobe Employee
    vraghavAdobe EmployeeAccepted solution
    Adobe Employee
    December 22, 2016

    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

      Terms & ConditionsAccessibility statement

      Loading footer...