
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Selection for IF Clause
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.
- Tags:
- filter change
- if-else
Accepted Solutions


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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;


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
why do you need the third condition ?
what's your desired result on UI ?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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;

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
This works perfectly,
Thank you ..!!

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Then please close the thread by marking the correct answer as correct
