Forum Discussion
agkolkata
3 years agoRegular Visitor
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...
- 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
3 years agoRegular Visitor
Addon question:
Can we use a combination of 2 variables and a fixed text as the replacement value in this ?
KT_Bsmart2gethe
Impactful Individual
3 years agoHi agkolkata ,
Yes, you can, but you in to add a conditional statement.
I have a video explain the Table.ReplaceValue function.
Regards
KT