Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Update a value based on another value

I have a table and there is a null based on a missing persons name.  I want to update null with a value.  This table contains an id and name. The only person I didn't have in a table with ID 685.  I ...
Need Help
  • parry2k's avatar
    parry2k
    7 years ago

    Anonymous this will do it

     

    = Table.ReplaceValue(#"Reordered Columns",each [Forecast Manager],
    each if [Forecast Manager Id] = 685 and [Forecast Manager] = null then 685 else [Forecast Manager],
    Replacer.ReplaceValue,{"Forecast Manager"})
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thanks but Replace value replaces all nulls I only need to update the null for ID 685  Forecast Manager ID 685 needs a name in the Forecast Manager field.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

I tried to follow that logic but it doesn't like my attempt:

 

#"Reordered Columns" = Table.ReorderColumns(#"Renamed Columns1",{"ID", "Name", "Period", "Year", "Created", "Updated", "Forecast Manager ID", "Forecast Manager", "Submitted", "ResourceAllocation", "Report Period"}),
#"Replaced Value" = Table.ReplaceValue(#"Reordered Columns", each if Text.Contains([Forecast Manager ID],"685") then "Rita Carnes" else [Forecast Manager])
in
#"Replaced Value"

  • parry2k's avatar
    parry2k
    Super User
    7 years ago

    Anonymous are you getting an error? Without knowing what error you are getting, it is hard to imagine what is going on.

     

    What is data type for your [Forecast Manager Id] column?

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Expression.Error: 2 arguments were passed to a function which expects 5.
      Details:
      Pattern=
      Arguments=List

      • parry2k's avatar
        parry2k
        Super User
        7 years ago

        Anonymous did you followed the post which i sent earlier on how to replace with condition?