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"})
CNENFRNL's avatar
CNENFRNL
Community Champion
5 years ago
= Table.ReplaceValue(#"Changed Type", each [RECORDTYPEID], each #"crm_RECORDTYPE"[NAME]{List.PositionOf(#"crm_RECORDTYPE"[ID], [RECORDTYPEID])}, Replacer.ReplaceValue, {"RECORDTYPEID"})