Forum Discussion

tlt's avatar
tlt
Regular Visitor
9 years ago

Aggregating duplicate identifiers and Find/Replace based on Excel Table

Simple Question:  Is there a way to drive a find/replace based on an excel table, with a 'Find' and 'Replace' column?   Longer version / background: For the curious and brave (maybe bored?), below ...
Need Help
Tutorial Requests
v-caliao-msft's avatar
v-caliao-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

tlt,

 

In Query Editor, we can use Replance Value feature to replce the value we need. However, we can only hard code the "Value to Find" and "Replace With".

 

To work around this requirement, you could create another table to search value from anther table and return another column value by using LOOKUPVALUE function.
https://msdn.microsoft.com/en-us/library/gg492170.aspx

 

Regards,

Charlie Liao