Assigning next value to a population | Community
Skip to main content
M
MLong1427
Level 2
January 30, 2020
Solved

Assigning next value to a population

  • January 30, 2020
  • 1 reply
  • 2244 views

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?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Jonathon_wodnicki

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

1 reply

Jonathon_wodnicki
Community Advisor
Jonathon_wodnickiCommunity AdvisorAccepted solution
Community Advisor
January 30, 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

Terms & ConditionsAccessibility statement

Loading footer...