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.
