topic Re: Field from map not found in App Development

Field from map not found

Anonymous — Fri, 16 Nov 2018 03:56:32 GMT

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);

Re: Field from map not found

dplr-rn — Thu, 15 Nov 2018 17:56:39 GMT

Move the if statement into a preceding load
you are deriving Item Desc and trying to use it in same load statement
something like
load *,
IF(WildMatch(Country,'*United States*') and WildMatch(Item Desc,'*Population*'),'Referencible','N/A')AS [Action]
;
load
Location
......

Re: Field from map not found

NZFei — Thu, 15 Nov 2018 20:15:28 GMT

Are you sure in your spread sheet 2, the column header for item description is called "Item Desc," with a comma at the end?

Re: Field from map not found

Anonymous — Thu, 15 Nov 2018 22:20:31 GMT

Tried that and it creates a synthetic key any other suggestions?

Re: Field from map not found

NZFei — Thu, 15 Nov 2018 22:34:00 GMT

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);