Forum Discussion
Adding A Cell as a Column to an Inner Table
The Table.TransformColumns function transforms columns independently. You cannot reference Column B in when defining a transformation on Column A. You can reference multiple columns when defining a new custom column or using Table.ReplaceValue.
I don't really understand what your ultimate goal is here but I don't think you'll likely make things more efficient by doing nested table operations rather than expanding tables.
The Table.TransformColumns function transforms columns independently. You cannot reference Column B in when defining a transformation on Column A. You can reference multiple columns when defining a new custom column or using Table.ReplaceValue.
I don't really understand what your ultimate goal is here but I don't think you'll likely make things more efficient by doing nested table operations rather than expanding tables.
I'm sorry, I just saw I never replied/accepted anything on this post. Thank you for pointing me in the right direction.
Rethinking about how I was coming at the problem ended up being the solution. There had been a previous case where working within inner tables ended up being the nicest solution, which is why I was attempting to do the same here.
