Notifications
Clear all
Topic starter
21/08/2022 12:18 pm
You create the following step by using Power Query Editor.
= Table.ReplaceValue(SalesLT_Address,"1318","1319",Replacer.ReplaceText,{"AddressLine1"})
A row has a value of 21318 Lasalle Street in the AddressLine1 column .
What will the value be when the step is applied?
- A . 1318
- B . 1319
- C . 21318 Lasalle Street
- D . 21319 Lasalle Street
Suggested Answer: D
Explanation:
Example:
Replace the text "ur" with the text "or" in the table.
Explanation:
Example:
Replace the text "ur" with the text "or" in the table.
Reference: https://docs.microsoft.com/en-us/powerquery-m/table-replacevalue