Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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 ...
Need Help
Jimmy801's avatar
Jimmy801
Community Champion
5 years ago

Hello Anonymous 

 

the code I posted was meant to add as formula once you add a new column in the GUI.

However to accelerate this you could try:

- go to advanced editor

- Add a new line where you write BufferedLookUpTable= Table.Buffer(#"Lookup_table"),

- change the value #"Lookup_table" to BufferedLookUpTable into your addcolumn-step

 

This means that you are buffering the lookup in a variable and giving this buffered table to invoke your funktion. So it's not needed to reread it on every row. This should do it.


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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Jimmy


Unfortunately, I have already done this, as I stated in the initial question. The #"Lookup table" query is

let Source = Excel.CurrentWorkbook(){[Name="Lookup_table"]}[Content],
in Table.Buffer(Source)

 

I have also tried putting the Table.Buffer part in the function itself, and to me it seems the effect is identical - both equally efficient?

  • Jimmy801's avatar
    Jimmy801
    Community Champion
    5 years ago

    Hello Anonymous 

     

    I think you have to add the table buffer in the query, where you are merging both of your queries, not in the orignal one

     

    BR

     

    Jimmy