Assigning next value to a population

MLong1427

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)

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)