Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Jolyon
Helper III
Helper III

add a blank when merging 2 columns?

Hi everyone,

 

need a little help:

 

I want to merge 2 columns with CONCATENATE([column1]; [column2]) and I get for example "10111Adworks"

But how can I add a blank between these values? -->to get "10111  Adworks"?

 

thanks in advance!

1 ACCEPTED SOLUTION
JoHo_BI
Responsive Resident
Responsive Resident

Hi Jolyon,

 

Try using CONCATENATE([column1]&" ", [column2])

 

The ampersand let's you add another function, or in this case an empty space after the first parameter. 

 

Hope this meets your needs!

View solution in original post

1 REPLY 1
JoHo_BI
Responsive Resident
Responsive Resident

Hi Jolyon,

 

Try using CONCATENATE([column1]&" ", [column2])

 

The ampersand let's you add another function, or in this case an empty space after the first parameter. 

 

Hope this meets your needs!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.