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

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?

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        I did read it so tried to write it myself based on that.   Can I do it  from the Replace Window?

         

        It's really simple 

        Replace Value 

         

        Value to Find :   Find Forecast Manager ID = 685

        Replace With:  Rita Carnes