Forum Discussion
How to Refer to Tables and Table Name Variables in Custom Functions
I'm struggling with referencing Tables (as type table) and Tablenames (as type text) in a Custom Function. I have the following (part of a function) where the bolden items need to refer to the Table ...
Whoah you're all up in the #sections that's pretty advanced--is all that necessary?
Anyway, in your first example you're using RandomTableName as the table for your nested join, but then as a table for the name of the nested column, which should be text--perhaps add NewTableName as text to your function.
--Nate
Thanks Nate, that would probably work, but I did think of that and I'd rather reduce duplication in my (all of my) code as it can make things confusing too. Also I'm ideally looking for a long term solution that I can apply to future custom functions that I will be creating too.