Is there anyway to do this, without using paths, because I don’t want to have to recreate and duplicate all the steps beyond this point. Over simplifying here:
App 1 has 3 fields, A, B, C
App 2 has 1 field D
Field D is filled with the contents of A or B or C depending on certain conditions. Sort of like a spreadsheet equation. =if(A=apple, then D=Apple) & if(B=Banana, then D=Banana) & if (C=coconut, then D=Coconut)
I don’t want to use a filter because I want it to continue no matter what, even if A was blank
Best answer by pshifrin
However, I did wind up doing my own version of this: The end results for D was numerical, and there were only 3 possible choices for A,B,C so I used a spreadsheet type formula that basically if A=Yes, then 5600, B=Yes, 5100 and C=Yes, 0. Then the field D is simply A+B+C (of the number transformation).
But absolutely, the lookup table is a much more efficient way to do this and would have combined 4 of my steps into 1.