Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Issue in data loading when relation is 1:N

Avatar

Avatar
Validate 10
Level 3
maheswarik23685
Level 3

Likes

21 likes

Total Posts

32 posts

Correct Reply

0 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile

Avatar
Validate 10
Level 3
maheswarik23685
Level 3

Likes

21 likes

Total Posts

32 posts

Correct Reply

0 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile
maheswarik23685
Level 3

01-09-2018

Hi All,

I have created 1: n link between 2 tables vehicle and warranty. vin (vehicle identification number) is the key which I have used for joining.

Vehicle Table -  has auto pk in all:vehicle

Warranty  Table - has auto pk in all:warranty. warranty certificate number is  defined as a key in extension schema (nmx:warrranty)

In the workflow for loading data for warranty schema I am using warranty certificate number as the reconciliation key.

When particular vin is not present in vehicle table corresponding record should be rejected in warranty schema but its inserting for me.

Could anyone provide some suggestions on how to fix this issue.

Thanks,

Maheswari

Replies

Avatar

Avatar
Validate 250
Level 10
pablo_rosero1
Level 10

Likes

81 likes

Total Posts

348 posts

Correct Reply

77 solutions
Top badges earned
Validate 250
Validate 100
Validate 50
Validate 25
Validate 10
View profile

Avatar
Validate 250
Level 10
pablo_rosero1
Level 10

Likes

81 likes

Total Posts

348 posts

Correct Reply

77 solutions
Top badges earned
Validate 250
Validate 100
Validate 50
Validate 25
Validate 10
View profile
pablo_rosero1
Level 10

03-10-2018

Hi Maheswari,

Is this for Campaign Standard or Classic?

One way to do it is to exclude all "vin is empty" from being populated with an exclusion:

Classic – https://cpcontents.adobe.com/public/newlearner/newlearner_be08c5ee.html#/learningProgram/6962/overvi...

Standard – https://helpx.adobe.com/lt/campaign/standard/automating/using/exclusion.html

Sorry for the delay and please let me know if this works for you