Forum Discussion

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago

Nested functions - unclear on scope impact

I have to do a complex fuzzy join between two tables involving multiple columns and weird conditions. As you can imagine performance is not great, and I am trying to find ways to optimize the step.  ...
Need Help
wdx223_Daniel's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity Champion
4 years ago

i guess:

1 function of or, when the left get a true then it will not calculate the right part.

2 function of and, when left part get a false then it will not calculate the right part.

so, the difference is how many times the formula to retrieve values from A.