Forum Discussion
Solved
Combining Columns
Hi everyone! I'd like to combine three columns together. When 'Park Name' is blank, I want it to add data from either community center & pool or community garden. When Park Name is blank then u...
Hey,
In your code you have [Park Name] = """""" for a value, so it looks for """" in the string.
Try:
= Table.AddColumn(#"Renamed Columns", "Combined Locations", each if [Park Name] = "" then [#"Community Center & Pool"] else [Park Name])
Thanks for your reply. It's still not pulling the names into the new column using null. Is there something else that needs to be added?
Any chance you can post that sample data as text?
