Forum Discussion
Correct Orders of Conditional column..
Dear Experts,
I think the wrong order of conditional colums, give a wrong number,
So, I am asking you to help me in a correct order.
Note: that thers is a leading zero, which is zero before a numbers, in some cases in my question is one zero
| Colum HS Code | Operator | Value | Output | |
| If | HS Code | Equal | 03011100 | Others |
| Else If | HS Code | Equal | 03011900 | Others |
| Else If | HS Code | Bigen with | 02 | Meat |
| Else If | HS Code | Bigen with | 03 | Fish |
| Else If | HS Code | Bigen with | 04 | Dairy |
| Else If | HS Code | Bigen with | 07 | Fruit & Vegetable |
| Else If | HS Code | Bigen with | 08 | Fruit & Vegetable |
| Else If | HS Code | Bigen with | 10 | Grain |
| Else If | HS Code | Bigen with | 1201 | Grain |
| Else If | HS Code | Bigen with | 1202 | Grain |
| Else If | HS Code | Bigen with | 1212 | Grain |
| Else If | HS Code | Equal | 12119010 | Grain |
| Else If | HS Code | Equal | 12119040 | Grain |
| Else If | HS Code | Equal | 12119050 | Grain |
| Else If | HS Code | Equal | 12119050 | Grain |
| Else If | HS Code | Bigen with | 15 | Fats & Oil |
| Else If | HS Code | Bigen with | 1704 | Others |
| Else If | HS Code | Bigen with | 17 | Sugar |
| Else | Others |
1 Reply
- jennratten
Super User
Hello - please provide more information about what you are trying to accomplish vs. what's actually happening. Please also add your script and paste a sample data table for us to better assist you.
