How to concatenate columns with different data types?

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 -

Then here I am concatenating Year column with Region -

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

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

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

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

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

Best Wishes,

Lesley

Hi Lesley,

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

Regards,

Vandana

Hey Vandana,

I hope you had a lovely weekend!

Great! Let me know how it goes :)

Best Wishes,

Lesley

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

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

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