PdfPrep.com

What will the value be when the step is applied?

You create the following step by using Power Query Editor.

=

Table.ReplaceValue(SalesLT_Address,"1318","1319",Replacer.ReplaceText,{"AddressLine 1"})

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

Answer: D

Explanation:

Example:

Replace the text "ur" with the text "or" in the table.

Reference: https://docs.microsoft.com/en-us/powerquery-m/table-replacevalue

Exit mobile version