Forum Discussion

ThomasSan's avatar
ThomasSan
Icon for Helper IV rankHelper IV
4 years ago
Solved

Replace text with content from other column

Hi everyone,   I am attempting to dynamically replace the headers of my table. My headers contain the string BLY, LY and CY which stand for "Before Last Year", "Last Year" and "Current Year", respe...
Need Help
  • AlexisOlson's avatar
    AlexisOlson
    4 years ago

    What is the error message?

     

    If it's complaining that 2019 isn't text, then you can wrap #"Transposed Table"{30}[Column2] with Text.From.

AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper User
4 years ago

The error is because it thinks you're trying to reference the Column2 field of the single element list { 32 }.

 

I think this is what you intended:

= Table.ReplaceValue(#"Transposed Table","BLY",#"Transposed Table"{30}[Column2],Replacer.ReplaceText,{"Column1"})
  • ThomasSan's avatar
    ThomasSan
    Icon for Helper IV rankHelper IV
    4 years ago

    Hi AlexisOlson ,

     

    thank you for your reply. You are right, {32} was an error. Having applied your formula, however, I only get errors generated in column1.

    Do you have any idea where the problem lies?

     

    P.S.: = #"Transposed Table"{30}[Column2] is at least generating the right value (i.e. 2019)

     

    • AlexisOlson's avatar
      AlexisOlson
      Icon for Super User rankSuper User
      4 years ago

      What is the error message?

       

      If it's complaining that 2019 isn't text, then you can wrap #"Transposed Table"{30}[Column2] with Text.From.

      • ThomasSan's avatar
        ThomasSan
        Icon for Helper IV rankHelper IV
        4 years ago

        AlexisOlson 

        great, that was the final key! Thanks a lot for your help!

         

         

        for others

        the final formula should read 

         

        = Table.ReplaceValue(#"Transposed Table","BLY",Text.from(#"Transposed Table"{30}[Column2]),Replacer.ReplaceText,{"Column1"})