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
Solved! Go to Solution.
Hello @Andrea92 ,
I have created a little workflow that may suit your needs.
Hope it helps 🙂
regards
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
It's a good idea but doesn't work because in append fields there more than 16 records in the source
It's a good idea but doesn't work because in append fields there are more than 16 records in the source
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.
You can of course go around it to allow all appends.
Cheers,
Angelos