How to concatenate columns with different data types?

Vandana Jagtap shared this question 2 years ago
Answered

How to concatenate columns with different data types?

3 columns- Date, Text, Text

Replies (6)

photo
1

Hey Vandana,

I hope you are well!


In order to concatenate 3 columns, all you need to do is the following, and i will be using column 1, 2, and 3 and in my example

add column 1, 2 and 3 to your report

Add an Advanced function to column 1 > concatenate with column 2

Now add an advanced function to column 3 > concatenate with the previously concatenated column


I have included my own test example below -


So here I have my 3 columns - Year, Region and Demographic -

4cc5ccd4d9ef268699fed4d34616ca04


Then here I am concatenating Year column with Region -

35fe63c17b270eb81425ecd8d452ecd1


And here are the results, the column is now called Addition of Column To Year -

0f455dc230e36da3f731de8c5e66cadf


Then here I am concatenating the Demographic field with the new column 'Addition of column to Year' -

df1c564cd6d31af28e67dd7dd1639c21


Which, as you can see, has concatenated all 3 columns - as it now includes the demographic, Year & Region -

8569f69de9b223f4981f8e8f3eeafbd9


And then as an extra step, if you would like to only show the concatenated field, you can 'hide' the others -

3dc6ecee986c8c949eb2f86c6c8c78a0


I hope this helps! Let me know if you have any further questions :)

Best Wishes,

Lesley

photo
1

Hi Lesley,

Thanks for detailed steps. Let me try this and will get back if I have any question.

Regards,

Vandana

photo
1

Hey Vandana,

I hope you had a lovely weekend!


Great! Let me know how it goes :)


Best Wishes,

Lesley

photo
1

Hey Vandana,

I hope you are well :)


I just wanted to check in to see if you were able to successfully concatenate the 3 desired columns?


Best Wishes,

Lesley

photo
1

Hey Vandana,

I hope you have been well and having a great week so far! :)


I just wanted to let you know, that I will be marking this ticket as closed due to inactivity, however, if you are still stuck on concatenating the 3 columns, let me know and we can jump on a call to go through it. I will be happy to help


Best Wishes,

Lesley

photo
1

Hi Lesley,

Sure, please proceed to close the ticket. Customer has not responded yet. I will get back to you if there are any further questions.

Regards,

Vandana

Leave a Comment
 
Attach a file