CODEWITHSUNDEEP
amazon-quicksight
Mark k
Mark k

Reputation: 153

Multiple replaces on a column in an AWS Quicksight dataset

I'm very new to AWS Quicksight and I'm trying to do multiple replaces on a column in a dataset. I thought that something like this calculated field would work:

replace(replace({Registered Owner}, 'LIMITED', 'Ltd'),{Registered Owner},'kft', 'Ltd')

But it doesn't look like you can nest Replace statements.

Any one can assist on how i might achieve this?

Regards, Mark

Upvotes: 0

Views: 1358

Answers (1)

Pankaj
Pankaj

Reputation: 2746

Here is an example of using nested replace -

replace(replace(replace({Email}, '@','ATTHERATE'),'.com','.org'),'email','quicksight')

Will result into following -

enter image description here

Upvotes: 1

Related Questions