Forum Discussion
pelowski
Helper III
Helper IIIChanging context of column reference in each statement
What I would like to do here is dynamically reference a column name in a previous PQ step from within an each statement. Does this require an Expression.Evaluate operation? How can I refer to a cha...
Put
Table.Column(Data, [Column])in the brackets for the List.Distinct
It's quite powerful but difficult to find.
HotChilli
Community Champion
Community ChampionPut
Table.Column(Data, [Column])in the brackets for the List.Distinct
It's quite powerful but difficult to find.
pelowskiHelper III
Helper IIIWow! It was as easy as that! Thanks!
FWIW, I swear I've been over that documentation hundreds of times but I think this is the first time I've used Table.Column! 🙄 Always learning something new! Thanks again!