Append or Concat the Fields

Question & Answer
, ,
1

How to append two columns into one column in quick sight?

2

Hi @Vaibhav.narwade
could you please explain a bit more, what you mean?
BR

3

@ErikG
@David_Wong
How to append two columns into one column in quick sight?

4

Hi @Vaibhav.narwade

one option would be to concat, in case of string columns

concat(column1,' - ',column2)

BR

5

I know the Concat function.
I want to union the two column.

6

What about

7

Hello @ErikG,

I want to stack the columns.
For example we have Column: col1, col2, col3
so, how we can stack?
like column:
col1
col2
col3
in quick sight

8

are you looking at pivot format?

9

Hello @Vaibhav.narwade, since we have not heard back from you, I will archive this question. If you still need assistance with this issue, please post a new topic in the community, link to this topic, and let us know what you have done to try and resolve this. That will ensure you are at the top of the priority list for a response from one of our QuickSight experts.

Based on my understanding, you will likely want to build a new dataset in QuickSight, where you utilize custom SQL to set up the row values to be determined by the columns you are currently pulling in with your dataset. Through where clauses and unions, you can create groupings way more efficiently and set up you table that way.

Thank you!