community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Handling 'greater than' & 'less than' values in Alteryx

Asteroid

I have a input data table given below. The value is in V-String format

 

GradeValue
MNNI>0.5
MIY<1
JIP>1
QQI0.75
IJK<0.8

 

I need to change this data table to the below format

 

GradeValueLowerUpper
MNNI 0.5 
MIY  1
JIP 1 
QQI0.75  
IJK  0.8

 

How can i do this in alteryx? Any ideas? Thanks. 

Highlighted
Alteryx Certified Partner

Hey @GaRaGe

 

How about something like this?

 

Grades.PNG

Labels