Forum Discussion

DIACHROMA's avatar
DIACHROMA
Helper II
5 years ago
Solved

Power Query - Replace values from another table without merging

Hi everyone,   I would like to replace values in a column from corresponding values in another table avoiding merging and expanding columns.   I have multiple queries with RecordType IDs in colum...
Need Help
Tutorial Requests
  • CNENFRNL's avatar
    CNENFRNL
    5 years ago
    = Table.ReplaceValue(#"Changed Type", each [RECORDTYPEID], each #"crm_RECORDTYPE"[NAME]{List.PositionOf(#"crm_RECORDTYPE"[ID], [RECORDTYPEID])}, Replacer.ReplaceValue, {"RECORDTYPEID"})
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Try this formula:

 

=let id = each [RECORDTYPEID] in Table.TransformColumns(#"Changed Type", {{"RECORDTYPEID", each Text.Replace(_, [RECORDTYPEID], Text.Find(crm_RECORDTYPE, id)[Name])}})

 

--Nate