Combining values in 3 columns to one column

Question & Answer
1

I have a data in which 3 columns(source 1, source 2, source3) are there having URL’s as data.
I need to create a single column in which the data/URL from all the three sources show up combined.
So that I can use them for creating a visual in which it shows how many times a URL has occurred.
On checking I am getting prompted to create a new data set.
Would it be possible to create this without the need to making a new dataset?

2

Hi @Mudgal - Welcome to AWS QuickSight community and thanks for posting the question. Yes, you can join 3 columns and make one column. Please see the concat command to do the same. Please find the document link below. Concat - Amazon QuickSight

Regards - Sanjeeb

1 Like
3

Hi @Sanjeeb2022 , thanks for quick response.
This link is helpful, but my ask here is if I can get all the URL’s in a single field from sources 1,2 & 3.
If I go as per the link, it would only show the combined values which we receive after using ‘concat’.
I would like to get the listing of all the URL’s/data in a single column from all 3 sources.

Regards - Himanshu

1 Like
4

Hi @Mudgal - Ok. Your use case is to bring values from 3 different sources and concat to each other. Do you have any joining condition for this 3 data sources. If yes, you can have 3 options.

  1. Create a custom data set by bringing 3 data sets to QuickSight and join at QuickSight.
  2. Create a custom sql and create a sql and at run time create a custom column and extract the details.
  3. Create a view at source details and concat that field at database level and bring the data to QuickSight

Regards - Sanjeeb

2 Likes
5

Hi @Sanjeeb2022 , yes this is helpful.
Thank you :slight_smile:

Regards - Himanshu

2 Likes
6

Hi @Mudgal - Thanks… If the suggestion is useful, please mark as Solution so that it can help others.

Regards - Sanjeeb

1 Like