Forum Discussion
Changing the data variable
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!
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."
