Map product name

[Anonymous]

I want to use ApplyMap with a concatenated field but this is the script editor error message I get.

Started loading data

MapIt << Sheet2 Lines fetched: 44

The following error occurred:

Field 'Key Field' not found

The error occurred here:

?

Data has not been loaded. Please correct the error and try loading again.

This is my script.

MapIt:

Mapping Load

[Order Number]&[Brand]&[Motor Type] as "Key Field",

Product

FROM [lib://Motors/Motors.xlsx]

(ooxml, embedded labels, table is Sheet2);

Details:

LOAD

    "Order Number",

    Brand,

    "Motor Type",

    [Order Number]&[Brand]&[Motor Type] as "Key Field",

    ApplyMap('MapIt', "Key Field", null()) as ProductName

FROM [lib://Motors/Motors.xlsx]

(ooxml, embedded labels, table is Sheet1);

This is from Sheet1

Order Number	Brand	Motor Type
100388	Volkswagen	Compacts
100388	BMW	SAVs
100388	BMW	Sedans
100388	BMW	Coupes
100388	BMW	Convertibles
100388	BMW	SAVs
100388	Volkswagen	Convertibles
100388	Volkswagen	SUVS
100388	Volkswagen	SUVS
100879	BMW	Sedans
100879	BMW	Coupes
100879	BMW	Convertibles
100879	BMW	Sedans
100879	Volkswagen	Compacts
100879	Volkswagen	Sedans
100879	BMW	Coupes
100879	BMW	Convertibles
100879	BMW	SAVs
100879	BMW	Sedans
100890	BMW	Sedans
100890	BMW	Convertibles
100890	BMW	Sedans
100890	Volkswagen	Compacts
100890	Volkswagen	Wagons
100923	Volkswagen	Sedans
100923	BMW	Coupes
100923	BMW	SAVs
100923	Volkswagen	Wagons
100923	BMW	Coupes
100930	BMW	Coupes
100930	BMW	Coupes
100930	BMW	Coupes
100930	BMW	Coupes
100930	BMW	Sedans
100930	Volkswagen	Compacts
100930	BMW	Sedans
100930	BMW	Coupes
100930	BMW	SAVs
100930	BMW	SAVs
100936	BMW	SAVs
100936	BMW	Sedans
100936	BMW	Sedans
100936	Volkswagen	Compacts
100936	BMW	SAVs

This is from Sheet2

Order Number	Brand	Motor Type	Product
100388	Volkswagen	Compacts	Beetle
100388	BMW	SAVs	X5 Sports Activity Vehicle
100388	BMW	Sedans	7 Series Sedan
100388	BMW	Coupes	M2 Competition Coupe
100388	BMW	Convertibles	M4 Convertible
100388	BMW	SAVs	X2 Sports Activity Coupe
100388	Volkswagen	Convertibles	Beetle Convertible
100388	Volkswagen	SUVS	Tiguan
100388	Volkswagen	SUVS	Atlas
100879	BMW	Sedans	3 Series Gran Turismo
100879	BMW	Coupes	2 Series Coupe
100879	BMW	Convertibles	4 Series Convertible
100879	BMW	Sedans	6 Series Gran Turismo
100879	Volkswagen	Compacts	GolfGTI
100879	Volkswagen	Sedans	Passat
100879	BMW	Coupes	6 Series Gran Coupe
100879	BMW	Convertibles	2 Series Convertible
100879	BMW	SAVs	X4 Sports Activity Coupe
100879	BMW	Sedans	3 Series Sedan
100890	BMW	Sedans	3 Series Sports Wagon
100890	BMW	Convertibles	BMW i8 Roadster
100890	BMW	Sedans	M5 Sedan
100890	Volkswagen	Compacts	Golf R
100890	Volkswagen	Wagons	Golf SportWagen
100923	Volkswagen	Sedans	Jetta
100923	BMW	Coupes	ALPINA B6
100923	BMW	SAVs	X1 Sports Activity Vehicle
100923	Volkswagen	Wagons	Golf Alltrack
100923	BMW	Coupes	M6 Gran Coupe
100930	BMW	Coupes	BMW i8
100930	BMW	Coupes	4 Series Gran Coupe
100930	BMW	Coupes	M4 Coupe
100930	BMW	Coupes	4 Series Coupe
100930	BMW	Sedans	BMW i3
100930	Volkswagen	Compacts	e-Golf
100930	BMW	Sedans	5 Series Sedan
100930	BMW	Coupes	8 Series Coupe
100930	BMW	SAVs	X5 M Sports Activity Vehicle
100930	BMW	SAVs	X6 Sports Activity Coupe
100936	BMW	SAVs	X6 M Sports Activity Coupe
100936	BMW	Sedans	ALPINA B7
100936	BMW	Sedans	M3 Sedan
100936	Volkswagen	Compacts	Golf
100936	BMW	SAVs	X3 Sports Activity Vehicle

[undergrinder · Accepted solution]

Hi John,

At that step that field is not exist, change it to the definition.

Try this:

Details:

LOAD

    "Order Number",

    Brand,

    "Motor Type",

    [Order Number]&[Brand]&[Motor Type] as "Key Field",

    ApplyMap('MapIt', [Order Number]&[Brand]&[Motor Type], null()) as ProductName

FROM [lib://Motors/Motors.xlsx]

(ooxml, embedded labels, table is Sheet1);

G.