Selection for IF Clause

[satish25]

Hello Everyone,

I have the Following table:

Factory_Code
1002
1005
4001
4002
5001
5009
6113
7004
8001
8008
9000
9001

The expresssion is as follows:

If(WildMatch(Factory_Code,'4*'),'Exclude service center',

If(Factory_Code='5001' or

        Factory_Code= '9001' or

            Factory_Code='8001' or

                Factory_Code='1005' or

                    Factory_Code='8008','Exclude HO',

If(WildMatch(Factory_Code,'*'),'Standard'))) as Factory_Section.

In this code, I want the third condition to display all the Factory_Codes (i.e. it should include the values of 'Exclude service center' and 'Exclude HO' as well)

The Output should be as follows:

• Exclude service center = 4001,4002.
• Exclude HO = 5001, 8001,9001, 1005,8008.
• Standard = 1002, 1005, 4001, 4002, 5001, 5009, 6113, 7004, 8001, 8008, 9000, 9001.

However in Future, the Factory_Codes may increase or decrease.

So wanted the necessary changes to be made in the Code.

Thanks in Advance.

[agigliotti]

why do you need the third condition ?

what's your desired result on UI ?

[satish25]

I know that No selections with give all the Factory_Codes, but i want it to happen on the 'Standard' selection.

Basically that's a requirement I need to fulfil.

[agigliotti · Accepted solution]

you can do it with the below script:

load

    Factory_Code,

If(WildMatch(Factory_Code,'4*'),'Exclude service center',

If(Factory_Code='5001' or

        Factory_Code= '9001' or

            Factory_Code='8001' or

                Factory_Code='1005' or

                    Factory_Code='8008','Exclude HO' )) as Factory_Section

from your_table;

concatenate

load

     Factory_Code,

     'Standard' as Factory_Section

from your_table;

[satish25]

This works perfectly,

Thank you ..!!

[OmarBenSalem]

Then please close the thread by marking the correct answer as correct