Combining Columns

[olliehernandez]

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 use community center & pool.  And the next column to have the already conditioned column, to then include community garden.  When I add the conditional column, it's not combining the community center & pool or community garden column, it's only showing data from the park name column.  I'm not sure what I'm doing wrong.  Any help is greatly appreciated!  Thank you!

I'd like to combine these three columns into one, so I have all of the locations in one column.

= Table.AddColumn(#"Renamed Columns", "Combined Locations", each if [Park Name] = """""" then [#"Community Center & Pool"] else [Park Name])

= Table.AddColumn(#"Added Conditional Column", "All Combined", each if [Combined Locations] = """""" then [Community Garden] else [Park Name])

When I've added that the only thing I'm coming back with are the park names in the columns, it's not adding the community centers or the community gardens into the new column.  Thank you!

[Chewdata · Accepted solution]

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])

[olliehernandez]

That's what it was!  Thank you!!

[olliehernandez]

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?

[Greg_Deckler]

Any chance you can post that sample data as text?

[Greg_Deckler]

@olliehernandez Try using null instead of ""