Expand my Community achievements bar.

SOLVED

What are 0 ID Records?

Avatar

Employee

Could someone explain what 0 ID Records are in general, and what this setting does?

HariharanB_0-1689146680497.png

 

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hi @HariharanB ,

In the import workflow example provided by @aggabhi , ( https://experienceleague.adobe.com/docs/campaign-classic/using/automating-with-workflows/use-cases/d... )

 

Lets consider in data loading activity, you import a CSV file with 10 recipient data, where 7 records already exist in database and 3 are new records.

And in enrichment, linking the input data with recipient schema using a simple join and selecting 'Type 11 simple link which may have a non-existent target' and run the workflow.

ParthaSarathy_0-1689165277187.png

 

You can see in the output transition, Primary key for those 7 recipients who already exists in database will have primary key value, whereas for other 3 new records primary key of recipients will be 0. These records are called 0 ID records as per the above documentation.

ParthaSarathy_1-1689165405761.png

 

In few cases these records might automatically filtered. If you notice such scenario, to avoid that you can enable the checkbox 'disable automatic filtering of 0 ID records' 

 

View solution in original post

5 Replies

Avatar

Level 6

Hi @HariharanB ,

 

Disable automatic filtering of 0 ID records option to make sure records that have a primary key equal to 0 are not excluded.

 

https://experienceleague.adobe.com/docs/campaign-classic/using/automating-with-workflows/use-cases/d...

 

Regards

Abhishek

Avatar

Employee

Hi Abhishek,
This answers the use of that setting, but could you please explain what is the purpose of 0 id records? and why is a 0 id record added to recipients by default?

 

Regards,

Hari

Avatar

Level 6

Thanks for your question.

Basically lets say you have two tables one is recipient and other id country table and recipient table is joined by country table by n:1 cardinality and country code is foreign key in same table.

 

Now there can be case when country is not populated for some recipients and that is case they have no value in foreign key of same table leading to zero id records.

 

These records are called zero id records.

 

Regards

Abhishek

Avatar

Correct answer by
Community Advisor

Hi @HariharanB ,

In the import workflow example provided by @aggabhi , ( https://experienceleague.adobe.com/docs/campaign-classic/using/automating-with-workflows/use-cases/d... )

 

Lets consider in data loading activity, you import a CSV file with 10 recipient data, where 7 records already exist in database and 3 are new records.

And in enrichment, linking the input data with recipient schema using a simple join and selecting 'Type 11 simple link which may have a non-existent target' and run the workflow.

ParthaSarathy_0-1689165277187.png

 

You can see in the output transition, Primary key for those 7 recipients who already exists in database will have primary key value, whereas for other 3 new records primary key of recipients will be 0. These records are called 0 ID records as per the above documentation.

ParthaSarathy_1-1689165405761.png

 

In few cases these records might automatically filtered. If you notice such scenario, to avoid that you can enable the checkbox 'disable automatic filtering of 0 ID records'