Assigning next value to a population

[MLong1427]

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?

[Jonathon_wodnicki · Accepted solution]

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