Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I need your help to manage special case found.
In database my field store numbers like 1, 2, 33, 1027.....
In fact, each 2^x represent specific value.
For example:
2^0=1 --> blue car
2^1=2 --> red car
2^2=4 --> orange car
.....
For a customer, this field stores any cars they have. If they have a blue car, value is simple: 1. If a customer have 2 cars, the value is the sum of the two values (example: 6 for a red and orange car). I have lots of combination so it seems impossible to create a pick/match function.
Do you have any idea to extract each single result (cars) in this example please ?
Regards
Regis
So, if a customer has a value of 4... does it mean that he has 3 cars (2 blue and 1 red) or 2 cars (2 red) or 1 car (1 orange)? if the value is summed, how will you differentiate?
that's not possible with map/applymap because when 2 values summed in the field the maping can't match each individual values
Example:
red car =1
blue car=2
myfield value is 3 and i need to retrieve the two values
Are you saying that you would know in advance how many cars each one of them have?
But value 7 can also mean 4 cars = 1 orange and 3 blue cars, isn't it?
I guess if I see a value, how do I know what makes it up... is it 4+2+1 or is it 4+1+1+1 or 2+2+2+1 or 2+1+1+1+1+1?