Forum Discussion

agkolkata's avatar
agkolkata
Regular Visitor
3 years ago
Solved

Can I use  variable inside Table.ReplaceValue function ?

Can I use  a variable inside Table.ReplaceValue function ? /#"Replaced Value32" = Table.ReplaceValue(#"Changed Type2","noFullApplicationNameTag",Text.From([meterCategory]),Replacer.ReplaceValue,{"cu...
Need Help
  • KT_Bsmart2gethe's avatar
    KT_Bsmart2gethe
    3 years ago

    Hi agkolkata ,

    Please see code below where I added "each" to 2nd and 3rd arguments: 

    Table.ReplaceValue(
   #"Changed Type2",
   each "noFullApplicationNameTag",
   each Text.From([meterCategory]),
   Replacer.ReplaceValue,
   {"custom_TagsFullApplicationName"}
)

     

    Regards

    KT

     

KT_Bsmart2gethe's avatar
KT_Bsmart2gethe
Icon for Impactful Individual rankImpactful Individual
3 years ago

Hi agkolkata ,

Please see code below where I added "each" to 2nd and 3rd arguments: 

Table.ReplaceValue(
   #"Changed Type2",
   each "noFullApplicationNameTag",
   each Text.From([meterCategory]),
   Replacer.ReplaceValue,
   {"custom_TagsFullApplicationName"}
)

 

Regards

KT

 

  • agkolkata's avatar
    agkolkata
    Regular Visitor
    3 years ago

    Addon question:

    Can we use a combination of 2 variables and a fixed text as the replacement value in this ? 

    • KT_Bsmart2gethe's avatar
      KT_Bsmart2gethe
      Icon for Impactful Individual rankImpactful Individual
      3 years ago

      Hi agkolkata ,

       

      Yes, you can, but you in to add a conditional statement.

      I have a video explain the Table.ReplaceValue function.

      Table.ReplaceValue 

       

      Regards

      KT