Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

TransformColumn error, cant apply Field access to type text

I have a column with Text and with numbers, my goal is, if its a number then Null else kept the Text value.   the Column type is mixed BUT if i do an "add Column" and use  if Value.Is([Value], type...
Need Help
  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    3 years ago

    Use this

    Table.ReplaceValue(#"Filled Up1", each [Value], each if [Value] is text then [Value] else null, Replacer.ReplaceValue, {"Value"})
Vijay_A_Verma's avatar
Vijay_A_Verma
Most Valuable Professional
3 years ago

Use this

Table.ReplaceValue(#"Filled Up1", each [Value], each if [Value] is text then [Value] else null, Replacer.ReplaceValue, {"Value"})