Forum Discussion

Jojojojo's avatar
Jojojojo
Frequent Visitor
3 years ago
Solved

How do you append multiple columns into one column?

Hi there, I'm pretty new to Power Query and am looking to append 5 diffrent columns into one. From my formula below, the new column only seems to populate data from the columns ([Initiative Des...
Need Help
  • AlexisOlson's avatar
    AlexisOlson
    3 years ago

    If I'm understanding correctly, this seems like a good use case for the coalesce operator.

    [Initiative Description] ?? [#"MAT - Initiative Description"] ?? [#"ENG - Initiative description"] ?? [#"WAT -Initiative description"] ?? [#"OTH - Initiative description"]

     

AlexisOlson's avatar
AlexisOlson
Super User
3 years ago

If I'm understanding correctly, this seems like a good use case for the coalesce operator.

[Initiative Description] ?? [#"MAT - Initiative Description"] ?? [#"ENG - Initiative description"] ?? [#"WAT -Initiative description"] ?? [#"OTH - Initiative description"]

 

  • Jojojojo's avatar
    Jojojojo
    Frequent Visitor
    3 years ago

    Thanks this worked for me! Followed what was on the post and wrote it out like:

    = Table.AddColumn(#"Added Custom3", "Initiative Description All", each
    if [Initiative Description] <> null then [Initiative Description]
    else if [#"MAT - Initiative Description"] <> null then [#"MAT - Initiative Description"]
    else if [#"ENG - Initiative description"] <> null then [#"ENG - Initiative description"]

    else if [#"WAT -Initiative description"] <> null then [#"WAT -Initiative description"]

    else if [#"WAT -Initiative description"] <> null then [#"WAT -Initiative description"]

    else if [#"OTH - Initiative description"] <> null then [#"OTH - Initiative description"] else "N/A")