Forum Discussion
Can I change data value from edit queries?
From edit queries, can I change all "1" to male and all "2" to female? i know i can create a new column and change them by if function. but can i change them from the existing columns?
Anonymous
1) in the Query Editor - select the column - Home tab - Data Type - change to Text
2) right-click on the column - Replace Values - 1 - Male
3) right-click on the column - Replace Values - 2 - Female
Good Luck! :smileyhappy:
Sean
Community Champion
Community ChampionAnonymous
1) in the Query Editor - select the column - Home tab - Data Type - change to Text
2) right-click on the column - Replace Values - 1 - Male
3) right-click on the column - Replace Values - 2 - Female
Good Luck! :smileyhappy:
- MarcelBeug
In the Query Editor, you can even click the data type icon in the column header (in this case, the "123" icon) and change to Text.
I just learned from the February 2017 Feature video about "Using Locale.." being added over there.
