Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Encoding numbers to text

Hello,   I have a unique situation where most of my values are coming in as their actual text value, but some are being decoded as a numeric value.     For example, 12345 would be encoded as MTIz...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Community Support
8 years ago

Hi Anonymous

Here are two options for your reference

 First create a custom column

Custom=Value.Is([value],Int64.Type)

  1. add a conditional column

 

Corresponding M query:

= Table.AddColumn(#"Added Custom", "Custom.1", each if [Custom] = true then "Basically" else [value])
  1. Replace values on original column directly.

= Table.ReplaceValue( #"Added Custom" ,each [value],each if [Custom] = true then "Basically" else [value],Replacer.ReplaceValue,{"value"})

Best regards,
Maggie

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Maggie,

 

Thank you very much.  I will try these solutions and will let you know how I make out.

 

Regards,

Pete