CODEWITHSUNDEEP
amazon-web-servicesamazon-quicksight
learning
learning

Reputation: 31

How to combine column in aws quicksight

I have

Year  Month Day
int   int   int
2021  10    21
2021  10    22
.....

I want to combine as whole date 2021-10-21 is this possible in quicksight?

how I can parse to date and create separate column as

date
2021-10-21

Upvotes: 1

Views: 5252

Answers (2)

Matt Cook
Matt Cook

Reputation: 372

In your data set you will need to create a calculated field, as your columns are integers you will need to convert them to strings and concatenate them similar to Marisa's answer

parseDate(concat(toString({Month}), '/', toString({Day}), '/', toString({Year})), 'MM/dd/yyyy')

Would create what I think you are looking for

Upvotes: 1

Marisa
Marisa

Reputation: 1

You should be able to do this by concatenating the date pieces into a string, and then using the parseDate function. I just tried it with parseDate(concat('10', '/', '21','/','2021'), 'MM/dd/yyyy') and it worked.

Upvotes: 0

Related Questions