Forum Discussion
Receiving errors when trying to pass and evaluate fields between functions
Hi Gabe_V ,
I don't understand the task that you want to achieve here.
One could check for the occurrance like so:
#"Added Custom" = Table.AddColumn(#"Flag 2b", "Flag 2 Test", each Text.Contains([DescriptionTypeValue], "(SMT)"))How would that differ from your desired result?
Hi ImkeF,
To quote the response I gave to a very similar question posed by AlienSx:
"That's a good question, and one that I knew would probably be asked eventually. Its mostly because this is a bare-bones version of the ultimate function, which will eventuall need to a) perform much more complex "if then" logic, and b) be able to take values from different tables' fields and compare them against each other, etc. "
I understand that I could very easily do exactly as suggested from within the referenced table, but I want to be able to make these kinds of checks across tables. This is what I hoped would be a very simple preliminary step to do that. I am getting the impression now that this is going to be a VERY complex task. I really didn't think it would be.