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...

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...