Changing the data variable

[Anonymous]

I am loading my data directly from Oracle Database. I have a column called Gender which takes values 'M' and 'F'. However, I want to change all M to Male and F to Female without creating any additional column for gender. 

How can this be done? Thank you!

[RMDNA · Accepted solution]

Hi @Anonymous,

To clarify, do you mean Import or actual DirectQuery?

If you're using Import, just Replace Values in Query Editor to change M to "Male" and F to "Female."

[Anonymous]

@RMDNA Hey this worked. I also created a column with examples and deleted the original column