Replace Strings M query

[han_rj]

Hi

I would like to achieve an optimal Mquery where In Side , Sun Side, Side should be replaced with Header annd others should  remain.

Issue faced using UI was that I had to create multiple replace transformation and when tried replacing Side all the rows were affected.

Thank You in advance for the help

[PwerQueryKees]

I totally agree wit the solution of @v-mdharahman .

Here as copy/paste-able text:

= Table.TransformColumns (Source,
    {{"TextColumn", each if List.Contains(ReplacementList, Text.Trim(_)) then "Header" else _, type text}}
)

[v-mdharahman · Accepted solution]

Hi @han_rj,

Thanks for reaching out to the Microsoft fabric community forum.

It looks like you want to replace selected values from rows with "Header" value and you want to use MQuery so that you don't have to create multiple transformation.

Here is the MQuery to replace selected data rows from your desired data:

Here "textColumn" is the name of the column in which you want to replace data with your desired data.

If I misunderstand your needs or you still have problems on it, please feel free to let us know. 

Best Regards,

Hammad.

Community Support Team

If this post helps then please mark it as a solution, so that other members find it more quickly.

Thank you.

[jgeddes]

This may work for you...

Table.ReplaceValue(#"Changed Type", each [Strings], each if List.Contains({"In Side", "Sun Side", "Side"}, [Strings]) then "Header" else [Strings], Replacer.ReplaceValue, {"Strings"})