Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Find matching range in another dataset
Added on March 12, 2023 6:51AM
Likes: 0
Replies: 2
yankees9920
Registered Posts: 2 ✭
I have a dataset of properties and their prices
| Address | Price |
| 123 Main St | 450,000 |
| 1 Broadway | 750,000 |
and another dataset that contains scores based on where the price falls within the range
| LowRange | HighRange | Score |
| 0 | 499,999 | 10 |
| 500,000 | 1,000,000 | 5 |
I'm looking to append a row to the first table that does a lookup to see what the score should be and would expect the following output.
| Address | Price | Score |
| 123 Main St | 450,000 | 10 |
| 1 Broadway | 750,000 | 5 |
I can't join these tables since they have no IDs in common and I haven't figured out a way to reference another dataset in a formula during the Prepare step. Any help would be appreciated!
Best Answer
-
Alexandru Dataiker, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 1,269 DataikerHi @yankees9920
,You should still be able to use a Join recipe in this case but with multiple join conditions with <= and >=
Let me know if that works for you!
In my example LowRange is min and HighRange is max. Output was :
Answers
-
Thank you very much, not sure how I missed that.
I have multiple scoring ranges/criteria that I use and I just discovered that I could use pre-joined computed column to further filter each join by the appropriate type