Format gender from database to localize text

Queries and Resources
,
1

I have gender column in database with "Male, Female, and Both" enums.

How can I change this data from table column to localized text which I set myself using conditional in mapped value functions?

Thanks

2

Hi @rony, I could be misunderstanding your question, but you could use JavaScript in a transformer or in a JS query to conditionally return different values, or set the value of another component! Could that work for your use case?