Forum Discussion

Mars3442's avatar
Mars3442
Icon for Helper I rankHelper I
2 years ago
Solved

Replace only null value with 2 conditions

Hi everyone, I want to ask a help for solving my problem I have a table like this I need to replace the null value with these conditional : Purchase number= null, Purchase 2 number = null, ...
Need Help
  • mlsx4's avatar
    mlsx4
    2 years ago

    Hi Mars3442 

     

    Try this 

    = Table.ReplaceValue(#"PreviousStepName",null,each if [Purchase number]=null and [Purchase 2 number]=null then "No data" else null,Replacer.ReplaceValue,{"Status"})
  • mlsx4's avatar
    mlsx4
    2 years ago

    Have you replaced the name of the previous step between ""? And the column name is "Status"?

    For me, it's working perfectly.

    Check also that previous line ends with a ",":

    #previousStep=.........(.....),

    #replaceNull= Table.ReplaceValue...

mlsx4's avatar
mlsx4
Icon for Memorable Member rankMemorable Member
2 years ago

Hi Mars3442 

 

Try this 

= Table.ReplaceValue(#"PreviousStepName",null,each if [Purchase number]=null and [Purchase 2 number]=null then "No data" else null,Replacer.ReplaceValue,{"Status"})
  • Mars3442's avatar
    Mars3442
    Icon for Helper I rankHelper I
    2 years ago

    It returns

    Expression.SyntaxError: Token Literal expected.

    Table.ReplaceValue(#"PreviousStepName",
    ------> ^
    null,each if [Purchase number]=null and [Purchase 2 number]=null then "No data" else null,Replacer.ReplaceValue,{"Status"}) 

    what should I do?

    • mlsx4's avatar
      mlsx4
      Icon for Memorable Member rankMemorable Member
      2 years ago

      Have you replaced the name of the previous step between ""? And the column name is "Status"?

      For me, it's working perfectly.

      Check also that previous line ends with a ",":

      #previousStep=.........(.....),

      #replaceNull= Table.ReplaceValue...