Expand my Community achievements bar.

Join us for Adobe Campaign Community Q&A Coffee Break on Thursday, March 7th at 8am PT with Eric Perrin, Gael Mouello, Chakravarthy Kalva, Bruce Swann and Sandra Hausmann.
SOLVED

Assigning next value to a population

Avatar

Level 2

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?

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

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

View solution in original post

1 Reply

Avatar

Correct answer by
Community Advisor

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