cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Matrices

SOLVED
Highlighted
Meteor

Hi Team, 

 

Can someone please help me with the below? 

 

This is slightly complicated.... Instead of using the formula (Alteryx attached below) to give me the IM column results I would like to use the text column to get the same result. (IM Column)

 

I am not sure how I can connect my text input data with the workflow to give me the IM Column results? 

Quasar

A Formula might be the easiest way, but if you want to manage it through a Text Input you could use something along these lines:

image.png

This adds all the thresholds to every record, checks which thresholds are less than the Days column, and grabs the largest threshold.  The RecordID tool is just to provide a unique field for the Unique tool --- if you have another field(s) that make each record unique, you can use those instead and eliminate the RecordID.

Meteor

many thanks !