Hi
I have a master table that sets out bands and a regional code for each band. The Master also has specific mappings for specific codes.
Where there is not an exact match I wish to merge based on a band. Where there is an exact match I wish to use the specific mapping contained in the Master table.
My scenario is set out in the attached file.
I am open to ideas as to how to do this - A conditional column seems laborious - are there other options?
Thank You
Allister
Please try
PHP Code:let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
AReg = Table.AddColumn(Source, "Region", each try Table2{[Code=[Code]]}[Region] otherwise
List.First(Table.SelectRows(Table2,(T)=> T[Code]<=[Code] and T[Code]> Number.ToText(Number.From([Code])-0.1,"0.000" ))[Region]) ?? "no mapping" )
in
AReg
Nice solution Bo_Ry
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks