How can I find a value in a dynamic range?

Andrea92

Hi all,

I need to find values content in (Table A column Average sale) in the range Table B.

For example we find the value 8.35 in the range 5.46- 10.46 or 4.81 in the range 4.43- 5.46.

Keeping in mind that intervals are dynamic how can I resolve the issue?

Thanks a lot for your help

Andrea

Table b.PNG

Capture.PNG

Tips and Tricks

Common Use Cases

Best Practices

Transformation

Help

Data Investigation

Accepted answers

AngelosPachis

Hi @Andrea92 ,

How big is your dataset? If the size permits, what you can use is use an appends fields tool to create all combinations of numbers and percentiles. Then with a filter tool, you cna check if the average sales for a given number is greater than or equal to the min value but less than or equal to the max value.

Hope that helps, let me know if that worked for you.

Cheers,

Angelos

example.yxmd

AngelosPachis

Hi @Andrea92 ,

You can change that from the configuration window of the Append Fields tool. There you get the option to define what happens when too many records are generated, which by default is set to error if there are more than 16 records.