Forum Discussion
BEST PRACTISE: Lookup in interval table
Hi. I have tried to put my challenge simple. Input: FACT Lookup_table Now, what I would like to do is Add column to FACT, where - The FACT[some number] is looked ...
Hello Anonymous
what you can do is to add a new column where you use a Table.SelectRows. Here some code that you get an idea what I mean
Table.SelectRows(Table.Buffer(Lookup_table), (sel)=> sel[from number]<_[some number] and sel[to number]>_[some number])
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy
Sorry for the late reply.
How is this different from my approach? I don't understand what is achieved here. Perhaps you could elaborate?