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.
