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

Cartesian product in workflow

Avatar

Avatar
Contributor
MVP
Milan_Vucetic
MVP

Likes

166 likes

Total Posts

383 posts

Correct Reply

135 solutions
Top badges earned
Contributor
Springboard
Shape 1
Validate 25
Validate 10
View profile

Avatar
Contributor
MVP
Milan_Vucetic
MVP

Likes

166 likes

Total Posts

383 posts

Correct Reply

135 solutions
Top badges earned
Contributor
Springboard
Shape 1
Validate 25
Validate 10
View profile
Milan_Vucetic
MVP

03-02-2020

Hi all,

 

we noticed a bigger number in output then in input for some SMS recurring deliveries.

milanv69354962_0-1580737286278.png

After checking, a cross join is performed for customers with more mobile phones and that is the reason for bigger number. (We have several records for the same recipient with different mobile phones which customer poses in recipient table.)

 

I am trying to find out why is used the cross join here as target mapping is done on mobile number level.

Any idea?

 

Regards,

Milan

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Establish
MVP
wodnicki
MVP

Likes

961 likes

Total Posts

1,090 posts

Correct Reply

509 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile

Avatar
Establish
MVP
wodnicki
MVP

Likes

961 likes

Total Posts

1,090 posts

Correct Reply

509 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile
wodnicki
MVP

03-02-2020

Hi,

 

Recipients exist as duplicates in recipient table for each of their phones?

NB not cross join- recipients exist on left side for the numbers.

 

Thanks,

-Jon

Answers (0)