Forum Discussion
Solved
Choose column - weird behaviour
I'm experiencing some weird behaviour in a dataflow. Here is the code: let Source = VP_Schedule, #"Filtered rows" = Table.SelectRows(Source, each [#"Paycode-level1"] = "Leave"), #"Choo...
Ignore this... I was just having a moment and didn't realise I had an error in an sql query...
#"Renamed columns" = Table.RenameColumns(#"Choose columns", {{"PERSONFULLNAME", "PERSONNUM"}}),
Are you saying you now have two PERSONNUM columns in that table? Usually Power Query does not allow you to do that.