Concatenate columns in query editor with delimiter

[danielrsnyder]

I am trying to concatenate 3  text columns into one column, separated by a semi colon, in query editor which sounds simple, but I am only getting null values?

I am trying to concatenate the three soft credit fields in the picture below. THanks in advance for your help!

[ChrisMendoza · Accepted solution]

hello @danielrsnyder, I had the same results.

Try Text.Combine. Edit - of course that is assuming you do not have number in store credit.

= Table.AddColumn(#"Added Custom", "Text.Combine", each Text.Combine({[SoftCredit],[Soft Credit_1],[Soft Credit_2]},"; "))

[danielrsnyder]

Thanks @ChrisMendoza, that worked and is much simpler than my solution!

[Greg_Deckler]

Hmm, that's strange as that looks like the right syntax.

[danielrsnyder]

I just did a nested if outside of the query editor and that works, but would have been a lot easier in the editor it seems.

Soft Credit = IF(not ISBLANK('Gifts Last Week'[Soft Credit_2]),'Gifts Last Week'[SoftCredit] & "; " & 'Gifts Last Week'[Soft Credit_1] & "; " & 'Gifts Last Week'[Soft Credit_2],if(AND('Gifts Last Week'[Soft Credit_2]=BLANK(),not ISBLANK('Gifts Last Week'[Soft Credit_1])),'Gifts Last Week'[SoftCredit] & "; " & 'Gifts Last Week'[Soft Credit_1],'Gifts Last Week'[SoftCredit]))