Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
However in Future, the Factory_Codes may increase or decrease.
So wanted the necessary changes to be made in the Code.
Thanks in Advance.
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;
why do you need the third condition ?
what's your desired result on UI ?
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.
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;
This works perfectly,
Thank you ..!!
Then please close the thread by marking the correct answer as correct