Forum Discussion
transform a column for use as array in other PowerQuery commands
Hi, I have an excel where power query does some manipulations. The idea is that I provide a certain table, where the user can create a "mapping", for example: In this table, NR: the sort...
Well, somethings writing the problem down solves the problem itselfs...
This did the trick:
and now I can use this in (dynamically) "change type" queries like
cheers!,
bartplessers
That works better and is easier. I tried and must have had a typo when testing Expression.Evaluate because I was getting errors when I was first doing it so that's why I did the #shared thing.
