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

Data match within range

Highlighted
Atom

Hi,

 

I've got two tables as per below. I need to assign Output in table two based on the Category and Value falling with ranges.

 

There are multiple categories. Ranges are different per category. Ranges will change over time.

 

So ideally this would be dynamic solution. Any ideas?

 

Thanks,

 

Viktor

 

CategoryLower rangeUpper rangeOutput
ABC051
ABC5.0001152
ABC15.0001303
ABC30.0001504
ABC50.00011005
DEF041
DEF4.0001122
DEF12.0001243
DEF24.0001484
DEF48.00011005

 

CategoryValueOutput
ABC3?
ABC13?
ABC23?
ABC33?
ABC43?
DEF2?
DEF12?
DEF22?
DEF32?
DEF42?
Alteryx Partner

Hi @Viktor1, I would use a join by category then a filter to exclude unwanted rows. You can change your input whenever you need.Capture.JPG

 

 

 

 

Atom

Thanks!

Atom

Hi!

 

I have a similar problem but I only have "ABC" data.

 

Problem is that I have 20 million rows and and 300 "range criterias" instead of 5 which it is in this example. This join function creates 300 new rows for each row. That means I will have 6 bn rows which I will then apply the filter on. This will take to much time to do in Alteryx.

 

Is there a way to do this that does not take that much processing power?

 

Thanks!

Labels