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

Assigning next value to a population

Avatar

Avatar
Level 1
MLong1427
Level 1

Likes

0 likes

Total Posts

11 posts

Correct Reply

0 solutions
View profile

Avatar
Level 1
MLong1427
Level 1

Likes

0 likes

Total Posts

11 posts

Correct Reply

0 solutions
View profile
MLong1427
Level 1

30-01-2020

Hello,

 

I have a table with a set list of card values and I want to assign them to my inbound population.  Both tables don't have a field I can join on in the traditional sense.  If a card value has a promotion history id assigned to it then it can't be used.  I heard a cross join could be used but I am not sure of the java that is required.

 

Any ideas?

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Establish
MVP
wodnicki
MVP

Likes

960 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

960 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

30-01-2020

Hi,

 

Every recipient gets a copy of all cards (cross)? Every recipient gets one of the available cards (left join on line number)?

Neither join would require java, but for 1:n a pivot does have to be applied (n has to be specified).

 

Thanks,

-Jon

Answers (0)