I have a dataset containing employee details with a ‘Location’ column(Sample is given below). In that column I need to change the string ‘Bengaluru’ to ‘Bangalore.’ However, after loading the data from files, I couldn’t find an option to do so. I’m new to QuickSight, and any assistance with this issue would be greatly appreciated.
Location
Bengaluru
Kolkata
Bengaluru
Vizag
Hyderabad
Hyderabad
Kochi
Kolkata
Chennai
Kolkata
Trivandrum
Bengaluru
Trivandrum
Kochi
Hyderabad
Kochi
Kochi
Hi @Fatima,
you can create a new calculated field.
new_location = ifelse({location}="Bengularu","Bangalore",{location))
BG
Thanks for your help.it is worked