Hi, I am trying to use ApplyMap function in a script. For this I created a table which I loaded from an Excel file. Then I tried to use the Mapping Load attribute. I get always the error "Map_ID"not found or the field name not found. Here is what I am doing:
LOAD //table name is Hospitals Text(BCode) as BCode, Hospital_Name, text(Hospital_ID) as Hospital_ID, IsIshpuz, Data FROM [lib://DataFiles/Hospitals.xlsx] (ooxml, embedded labels, table is Hospitals)
Hosp_Map: // for mapping purposes Mapping Load Text(BCode) as BCode, Hospital_Name as HName Resident Hospitals; Drop Table Hospitals; //without this statement - I can't see the Hosp_Map table in the data model
Load *, ApplyMap('Hosp_Map',Hname) as Hosp_name
The idea is to bring the full name using Vlookup given BCode.
What am I missing or doing wrong?
Is there another way to achieve this in the Visualization part (Set Expression or something like that)?
