Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
My model looks like this:
Row 1:
Product 1 Name - A
Product 1 Amount - 1
Product 2 Name - B
Product 2 Amount - 1
Product 3 Name - C
Product 3 Amount - 2
Product 4 Name - D
Product 4 Amount - 3
Product 5 Name - E
Product 5 Amount - 1
Combo Sale - True
Row 2:
Product 1 Name - D
Product 1 Amount - 1
Product 2 Name - E
Product 2 Amount - 1
Product 3 Name - B
Product 3 Amount - 1
Product 4 Name - A
Product 4 Amount - 0
Product 5 Name - C
Product 5 Amount - 1
Combo Sale - False
The product Names can be 1 of 5 different names: say A, B, C, D, and E
I want to add a column for "Combo Sale" that is True only if 2 different products are found with names A and B and a value > 1, like above
Is that possible?
I think I follow what youre saying, but just to clarify, if both A + B have >1 then 'Combo Sale' = true?
Yes, that's correct.