Alteryx Designer Desktop Discussions

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

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

GaRaGe
8 - 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. 

1 REPLY 1
LordNeilLord
15 - Aurora

Hey @GaRaGe

 

How about something like this?

 

Grades.PNG

Labels