Replace Column Values

Q&A
,
1

Hi All

I need help with replacing column values with mapping values

Ex:
Mapping info-
1=A , 2=B, 3=C , 4=D

Column A values-
1
2
2,3
4,1

Need to create calculated column with the values below based on the mapping -
A
B
B,C
C,A

Thanks in Advance for your Help

2

Hi @mahaquicksight and welcome to the Quick Sight community!
I would suggest trying out the switch function, you can find further documentation regarding this at the link below:

Let me know if this could work for your case or if you have any additional questions

3

Thanks @Brett

Column A Values are dynamic (it could be any combination of values )

4

Hi @mahaquicksight,
Could you share some screenshots of your scenario so that I can better understand how you’re trying to utilize this and how your fields that contain multiple values look?

5

Hi @mahaquicksight,
Following up here as it’s been awhile since we last heard from you; did you have any additional questions regarding your initial post or were you able to find a work around in the interim?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!