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.