You’re offline. This is a read only version of the page.
Announcements
2
Hello,
I want to replace some of the values of one column when it matches values from another query (table). I know I can use merge queries and conditional columns, but I want to use replace values.
E.g in the table below I need to replace the Department from "-" to "Sales" but not for every value in the Name column. Instead, I want to be able to provide the table with the names concerned (e.g just for Leo and Ken).
Any help is highly appreciated 😊
Name Department
| Josh | IT |
| Nathan | Services |
| Leo | _ |
| Margaret | _ |
| Ken | _ |
| Denis | IT |
| Flora | Services |
| Sandra | Services |
Share
Report
All responses (
Answers (
