Skip to Content
0
Former Member
Apr 22, 2007 at 06:54 AM

Variant Configuration - Subordinate values

66 Views

Hi,

Can anybody please help me out with the following issue that I am facing?

I have characteristic called 'Country' which has two Subordinate value nodes Europe, North America. The characteristic 'Country' can have multiple values and is 'Character' format. Under 'Europe' node, I have subordinate values such as 'France', 'England'. Under 'North America' node, I have subordinate values such as 'Canada', 'USA'.

The issue which I am facing is that while creating a procedure, I am unable to use statements such as IF Country IN ('3', '4') *where 3 is for France and 4 is for England.

Is there any way I can use the 'IN' statement for subordinate values or is there an alternative way?

My country list is quite big per continent so I don't want to use a statement like:

IF Country = '3' OR Country = '4' OR...

Please help me out with this.

Thanks in advance,

With best regards,

Sunil