I have a input data table given below. The value is in V-String format
| Grade | Value |
| MNNI | >0.5 |
| MIY | <1 |
| JIP | >1 |
| QQI | 0.75 |
| IJK | <0.8 |
I need to change this data table to the below format
| Grade | Value | Lower | Upper |
| MNNI | 0.5 | ||
| MIY | 1 | ||
| JIP | 1 | ||
| QQI | 0.75 | ||
| IJK | 0.8 |
How can i do this in alteryx? Any ideas? Thanks.
Solved! Go to Solution.
