Forum Discussion

elkay73's avatar
elkay73
Frequent Visitor
1 year ago
Solved

Power Query AddColumn with data from other table runs slow with List.PositionOf

I need to capture the data from the 'Answer' Column in Table1 into the new 'Answer' column in Table2.  Where the tables have a many to many relationship in the Column 'Names'.  And if there is no mat...
  • elkay73's avatar
    1 year ago

    I ended up adding a column with "= Table.ReplaceValue(#"Replaced Errors",null,"No",Replacer.ReplaceValue,{"SelfMed"})" as the code.