Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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 addition...
Need Help
  • RMDNA's avatar
    RMDNA
    8 years ago

    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."

RMDNA's avatar
RMDNA
Solution Sage
8 years ago

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's avatar
Anonymous
Not applicable
8 years ago

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