Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
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.
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.