Forum Discussion

Trebor84's avatar
Trebor84
Icon for Helper II rankHelper II
4 years ago

Slow transformation - List.Buffer or Table.Buffer as possible solution?

Hi,   Hoping someone can help with suggestions to speed up the code below please.   This code strips out part of a number and uses a hex2decimal conversion to convert the job ref.  This is curren...
Need Help
Trebor84's avatar
Trebor84
Icon for Helper II rankHelper II
4 years ago

Thanks for the suggestions, both pieces of code massivley speed up the conversions.

 

The merge still takes 20 minutes if anyone has a suggestion for that?

 

Thanks  

Vijay_A_Verma's avatar
Vijay_A_Verma
Icon for Most Valuable Professional rankMost Valuable Professional
4 years ago

Are you doing merge to perform VLOOKUP? Will you be getting a single value in every row or more than one value also?

  • Trebor84's avatar
    Trebor84
    Icon for Helper II rankHelper II
    4 years ago

    Hi, I use this for lookup to bring back a lat and long field from my other table.