Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to map the Item Desc field to TableMain then create a new field based on the contents in the Item Desc field however when I Load data I get an error message that says "The following error occurred:Field ‘Item Desc ‘ not found."
Here is my code
MapPop:
Mapping LOAD
"Local" AS "Location ",
"Item Desc"
FROM [lib://Data/Sheet2.xlsx]
(ooxml, embedded labels, table is Sheet2);
TableMain:
LOAD
"Location ",
"City",
"State",
"Country"
ApplyMap('MapPop’, " Location ", null()) as " Item Desc, ",
IF(WildMatch(Country,'*United States*') and WildMatch(Item Desc,'*Population*'),'Referencible','N/A')AS [Action]
FROM [lib://Data/Sheet1.xlsx]
(ooxml, embedded labels, table is Sheet1);
TableMain:
LOAD
"Location ",
"City",
"State",
"Country"
ApplyMap('MapPop’, " Location ", null()) as " Item Desc, ",
IF(WildMatch(Country,'*United States*') and WildMatch(ApplyMap('MapPop’, " Location ", null()),'*Population*'),'Referencible','N/A')AS [Action]
FROM [lib://Data/Sheet1.xlsx]
(ooxml, embedded labels, table is Sheet1);
Are you sure in your spread sheet 2, the column header for item description is called "Item Desc," with a comma at the end?
TableMain:
LOAD
"Location ",
"City",
"State",
"Country"
ApplyMap('MapPop’, " Location ", null()) as " Item Desc, ",
IF(WildMatch(Country,'*United States*') and WildMatch(ApplyMap('MapPop’, " Location ", null()),'*Population*'),'Referencible','N/A')AS [Action]
FROM [lib://Data/Sheet1.xlsx]
(ooxml, embedded labels, table is Sheet1);