Forum Discussion

dsabsi's avatar
dsabsi
Icon for Advocate I rankAdvocate I
9 years ago
Solved

How to add 2 text columns into one column

Hi guys,    I have 2 columns with text values, which I want to add together into 1 column.  Therefore, I think I need a formula but I can't find it on the forumn.      The first column contains...
Need Help
Show and Tell
  • MarcelBeug's avatar
    MarcelBeug
    9 years ago

    Option "Merge Columns" is also available on the "Add Column" tab, in which case the original columns will be kept and a new column will be added with the merged values.

dsabsi's avatar
dsabsi
Icon for Advocate I rankAdvocate I
9 years ago

Hi Guys, 

 

I tried both your solutions, and they are almost perfect. 

Interkoubess, how do you add space between the two tables, so that it becomes a1 b1? 

MarcelBeug, is there also another possibility except for merging, so that i can keep column A(first name) and column B(sur name)? Because with merging, I will lose those 2 tables but the result is very nice!

 

Many thanks for both of your replies!!!

 

I look forward to your solutions. 

 

Cheers, 

 

DSabsi

MarcelBeug's avatar
MarcelBeug
Icon for Community Champion rankCommunity Champion
9 years ago

Option "Merge Columns" is also available on the "Add Column" tab, in which case the original columns will be kept and a new column will be added with the merged values.

  • dsabsi's avatar
    dsabsi
    Icon for Advocate I rankAdvocate I
    9 years ago

    MarcelBeug, thank you very much, I used your solution and it works perfectly!! 

  • tghimire's avatar
    tghimire
    Regular Visitor
    6 years ago

    Hi MarcelBeug,

    Is it possible to merge 2 columns in Measures? We use live connection and I do not have rights to change anything in the data model. I want to concatenate 3 columns and show them in one in matrix or table visual. Any help will be appreciated.

     

    regards

    tanuj