Mapping data

[Anonymous]

Hi guys,

I have file with 2 variables Channel and Campaign with orderID.

I want to apply map for orderID to recode them to rgb color.

It works for only one variable.

Could you help me to understand why?

Please see my files.

Thanks,

[Jason_Michaelides]

What do you mean "It works for only one variable"?  Looks like it is working in your application?

[Anonymous]

it works for channel field, but if I select campaign, it doesn't show multicolor

[maxgro]

perhaps because the field orderID1 you use to map the color is not filled for Channel?

so you get 192, ...., ligthgray()

[Anonymous]

it works only with this condition

If(Fields='Campaign',  orderIDColor,

If(Fields='Channel',  orderIDColor1))

Could I modify or simple it to have only one variable orderIDColor?

Each channel has own number and each campaign has own number

I want, when I select channel or campaign, it shows own color.

Thanks,

[maxgro]

do you mean 1 field orderidcolor?

in your model you have some row with 2 orderid (orderid1 and orderid2), and 2 colors, so you need 2 fields 

to have only 1 field for color I suppose you must use a single field instead of 2 for Channel and Campaign,

1 field for color

1 added field for type (Channel or Campaign)

I do not know if it makes sense in your case

[Anonymous]

Whe I run load ,

I get a message

[maxgro]

drop the 2 tables NumberID and NumberID1 at the end

they have the same fields Red Green Blue and they create a loop in the model

in online help, search circular references for a detailed explanation