Is there a calculated field for CAST or CONVERT?

Question & Answer
1

Is there a calculated field for CAST or CONVERT? Right now I have to do this through my ETL job, but it would be easier in the future to be able to do that here. Essentially, I need to cast a date into CHAR. Any help is appreciated. Thanks

2

Is there any specific format that you want to CAST to?
You can also do it at the Edit Data step by changing the data type: Changing a Field Data Type - Amazon QuickSight

Alternatively, you can also create a calculated field to convert it ie parseDate - Amazon QuickSight

3

Thanks for responding!

Im looking to convert to text, so I can use in a word cloud. As of right now, I just do this in my ETL, but that may not always be possible or easy. Thanks!

4

You should be able to do it with a combination of extract, tostring and concat function in QuickSight calculated field, for example:

image
image717×212 9.11 KB

3 Likes
5

Thanks for including the formula - that really helps clarify the solution.