Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Check If String Column Contains A Value Greater Than a Number

andreahq
7 - Meteor

I want to check if a Column contains a value equal or greater than the value in another column. The thing is that the number of values separated by a "," in the second column might change.

 

Sample data:

Input

AB
11,2
23,4,5
31,2

 

Output:

Output
Y
Y
N
2 REPLIES 2
fmvizcaino
17 - Castor
17 - Castor

Hi @andreahq ,

 

You can use the following set of tools to accomplish that. Text to columns tool to separate the delimited values and the formula + summarize tool to identify is there is any higher value.

fmvizcaino_0-1587690704423.png

 

Best,

Fernando V.

 

andreahq
7 - Meteor

Thank you, this is a way simpler solution than I expected.

Labels