Forum Discussion

patrickoleary85's avatar
patrickoleary85
Frequent Visitor
2 years ago
Solved

Insert parameter from column A to column B

Hi there,

I have 2 columns in PowerQuery, text and CurrentValue. 

The value in 'text' contains {CurrentValue1}, which looks at the CurrentValue column. 

For the highlighted example with '40' in CurrentValue, the text needs to display "...for 40 has been submitted for review." 

You'll also see an example that has 'do' and 'P' in CurrentValue. 

How can I insert the text from the CurrentValue column into the {CurrentValue1} location in the text column?

Please note that the text column has a number of different variations ("{CurrentValue1} is missing a Training", "Course is missing for the user {CurrentValue1}.") so I cannot use a simple replace or split and then re-merge the columns since location is always different.

Thank you in advance!

 

Need Help
Tips and Tricks
  • CatSchneider's avatar
    CatSchneider
    2 years ago

    Add in a 'Replace Values' step from the Transform Tab, then update the step in the formula bar to:

    = Table.ReplaceValue(
    #"Name of your last step",
    "{CurrentValue1}",
    each _[CurrentValue],
    Replacer.ReplaceText,
    {"text"}
)


    And you end up with something like:

     

    Let me know if this helped!

2 Replies

  • CatSchneider's avatar
    CatSchneider
    Regular Visitor
    2 years ago

    Add in a 'Replace Values' step from the Transform Tab, then update the step in the formula bar to:

    = Table.ReplaceValue(
    #"Name of your last step",
    "{CurrentValue1}",
    each _[CurrentValue],
    Replacer.ReplaceText,
    {"text"}
)


    And you end up with something like:

     

    Let me know if this helped!