topic Map product name in App Development

topic Map product name in App Development https://community.qlik.com/t5/App-Development/Map-product-name/m-p/95189#M6337 <HTML><HEAD></HEAD><BODY><P>I want to use ApplyMap with a concatenated field but this is the script editor error message I get.</P><P></P><P class="headline undefined" style="padding: 0px 10px 0px 70px; font-weight: bolder; color: #595959; font-family: 'Courier New'; font-size: 13px;">Started loading data</P><P style="padding: 0px 10px 0px 70px; color: #595959; font-family: 'Courier New'; font-size: 13px;">MapIt << Sheet2 Lines fetched: 44</P><P class="headline edc_error" style="padding: 0px 10px 0px 70px; font-weight: bolder; color: #595959; font-family: 'Courier New'; font-size: 13px; background: rgba(255, 38, 38, 0.2);">The following error occurred:</P><P class="edc_error" style="padding: 0px 10px 0px 70px; color: #595959; font-family: 'Courier New'; font-size: 13px; background: rgba(255, 38, 38, 0.2);">Field 'Key Field' not found</P><P class="headline edc_error" style="padding: 0px 10px 0px 70px; font-weight: bolder; color: #595959; font-family: 'Courier New'; font-size: 13px; background: rgba(255, 38, 38, 0.2);">The error occurred here:</P><P class="edc_error" style="padding: 0px 10px 0px 70px; color: #595959; font-family: 'Courier New'; font-size: 13px; background: rgba(255, 38, 38, 0.2);">?</P><P class="headline undefined" style="padding: 0px 10px 0px 70px; font-weight: bolder; color: #595959; font-family: 'Courier New'; font-size: 13px;">Data has not been loaded. Please correct the error and try loading again.</P><P></P><P>This is my script.</P><P></P><P style="padding-left: 60px;">MapIt:</P><P style="padding-left: 60px;">Mapping Load</P><P style="padding-left: 60px;">[Order Number]&[Brand]&[Motor Type] as "Key Field",</P><P style="padding-left: 60px;">Product</P><P style="padding-left: 60px;">FROM [lib://Motors/Motors.xlsx]</P><P style="padding-left: 60px;">(ooxml, embedded labels, table is Sheet2);</P><P style="padding-left: 60px;"></P><P style="padding-left: 60px;">Details:</P><P style="padding-left: 60px;">LOAD</P><P style="padding-left: 60px;">    "Order Number",</P><P style="padding-left: 60px;">    Brand,</P><P style="padding-left: 60px;">    "Motor Type",</P><P style="padding-left: 60px;">    [Order Number]&[Brand]&[Motor Type] as "Key Field",</P><P style="padding-left: 60px;">    ApplyMap('MapIt', "Key Field", null()) as ProductName</P><P></P><P style="padding-left: 60px;">FROM [lib://Motors/Motors.xlsx]</P><P style="padding-left: 60px;">(ooxml, embedded labels, table is Sheet1);</P><P style="padding-left: 60px;"></P><P>This is from Sheet1</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 282px;"><TBODY><TR><TD height="20" width="98">Order Number</TD><TD width="98">Brand</TD><TD width="86">Motor Type</TD></TR><TR><TD align="right" height="20">100388</TD><TD>Volkswagen</TD><TD>Compacts</TD></TR><TR><TD align="right" height="20">100388</TD><TD>BMW</TD><TD>SAVs</TD></TR><TR><TD align="right" height="20">100388</TD><TD>BMW</TD><TD>Sedans</TD></TR><TR><TD align="right" height="20">100388</TD><TD>BMW</TD><TD>Coupes</TD></TR><TR><TD align="right" height="20">100388</TD><TD>BMW</TD><TD>Convertibles</TD></TR><TR><TD align="right" height="20">100388</TD><TD>BMW</TD><TD>SAVs</TD></TR><TR><TD align="right" height="20">100388</TD><TD>Volkswagen</TD><TD>Convertibles</TD></TR><TR><TD align="right" height="20">100388</TD><TD>Volkswagen</TD><TD>SUVS</TD></TR><TR><TD align="right" height="20">100388</TD><TD>Volkswagen</TD><TD>SUVS</TD></TR><TR><TD align="right" height="20">100879</TD><TD>BMW</TD><TD>Sedans</TD></TR><TR><TD align="right" height="20">100879</TD><TD>BMW</TD><TD>Coupes</TD></TR><TR><TD align="right" height="20">100879</TD><TD>BMW</TD><TD>Convertibles</TD></TR><TR><TD align="right" height="20">100879</TD><TD>BMW</TD><TD>Sedans</TD></TR><TR><TD align="right" height="20">100879</TD><TD>Volkswagen</TD><TD>Compacts</TD></TR><TR><TD align="right" height="20">100879</TD><TD>Volkswagen</TD><TD>Sedans</TD></TR><TR><TD align="right" height="20">100879</TD><TD>BMW</TD><TD>Coupes</TD></TR><TR><TD align="right" height="20">100879</TD><TD>BMW</TD><TD>Convertibles</TD></TR><TR><TD align="right" height="20">100879</TD><TD>BMW</TD><TD>SAVs</TD></TR><TR><TD align="right" height="20">100879</TD><TD>BMW</TD><TD>Sedans</TD></TR><TR><TD align="right" height="20">100890</TD><TD>BMW</TD><TD>Sedans</TD></TR><TR><TD align="right" height="20">100890</TD><TD>BMW</TD><TD>Convertibles</TD></TR><TR><TD align="right" height="20">100890</TD><TD>BMW</TD><TD>Sedans</TD></TR><TR><TD align="right" height="20">100890</TD><TD>Volkswagen</TD><TD>Compacts</TD></TR><TR><TD align="right" height="20">100890</TD><TD>Volkswagen</TD><TD>Wagons</TD></TR><TR><TD align="right" height="20">100923</TD><TD>Volkswagen</TD><TD>Sedans</TD></TR><TR><TD align="right" height="20">100923</TD><TD>BMW</TD><TD>Coupes</TD></TR><TR><TD align="right" height="20">100923</TD><TD>BMW</TD><TD>SAVs</TD></TR><TR><TD align="right" height="20">100923</TD><TD>Volkswagen</TD><TD>Wagons</TD></TR><TR><TD align="right" height="20">100923</TD><TD>BMW</TD><TD>Coupes</TD></TR><TR><TD align="right" height="20">100930</TD><TD>BMW</TD><TD>Coupes</TD></TR><TR><TD align="right" height="20">100930</TD><TD>BMW</TD><TD>Coupes</TD></TR><TR><TD align="right" height="20">100930</TD><TD>BMW</TD><TD>Coupes</TD></TR><TR><TD align="right" height="20">100930</TD><TD>BMW</TD><TD>Coupes</TD></TR><TR><TD align="right" height="20">100930</TD><TD>BMW</TD><TD>Sedans</TD></TR><TR><TD align="right" height="20">100930</TD><TD>Volkswagen</TD><TD>Compacts</TD></TR><TR><TD align="right" height="20">100930</TD><TD>BMW</TD><TD>Sedans</TD></TR><TR><TD align="right" height="20">100930</TD><TD>BMW</TD><TD>Coupes</TD></TR><TR><TD align="right" height="20">100930</TD><TD>BMW</TD><TD>SAVs</TD></TR><TR><TD align="right" height="20">100930</TD><TD>BMW</TD><TD>SAVs</TD></TR><TR><TD align="right" height="20">100936</TD><TD>BMW</TD><TD>SAVs</TD></TR><TR><TD align="right" height="20">100936</TD><TD>BMW</TD><TD>Sedans</TD></TR><TR><TD align="right" height="20">100936</TD><TD>BMW</TD><TD>Sedans</TD></TR><TR><TD align="right" height="20">100936</TD><TD>Volkswagen</TD><TD>Compacts</TD></TR><TR><TD align="right" height="20">100936</TD><TD>BMW</TD><TD>SAVs</TD></TR></TBODY></TABLE><P class="headline undefined" style="padding: 0 10px; font-weight: bolder; color: #595959; font-family: 'Courier New'; font-size: 13px;"></P><P class="headline undefined" style="padding: 0 10px; font-weight: bolder; color: #595959; font-family: 'Courier New'; font-size: 13px;"><SPAN style="font-size: 13.3333px; font-family: arial, helvetica, sans-serif;">This is from Sheet2</SPAN></P><P class="headline undefined" style="padding: 0 10px; font-weight: bolder; color: #595959; font-family: 'Courier New'; font-size: 13px;"></P><P>     </P><TABLE border="0" cellpadding="0" cellspacing="0" width="449"><TBODY><TR><TD height="20" width="98">Order Number</TD><TD width="82">Brand</TD><TD width="86">Motor Type</TD><TD width="183">Product</TD></TR><TR><TD align="right" height="20">100388</TD><TD>Volkswagen</TD><TD>Compacts</TD><TD>Beetle</TD></TR><TR><TD align="right" height="20">100388</TD><TD>BMW</TD><TD>SAVs</TD><TD>X5 Sports Activity Vehicle</TD></TR><TR><TD align="right" height="20">100388</TD><TD>BMW</TD><TD>Sedans</TD><TD>7 Series Sedan</TD></TR><TR><TD align="right" height="20">100388</TD><TD>BMW</TD><TD>Coupes</TD><TD>M2 Competition Coupe</TD></TR><TR><TD align="right" height="20">100388</TD><TD>BMW</TD><TD>Convertibles</TD><TD>M4 Convertible</TD></TR><TR><TD align="right" height="20">100388</TD><TD>BMW</TD><TD>SAVs</TD><TD>X2 Sports Activity Coupe</TD></TR><TR><TD align="right" height="20">100388</TD><TD>Volkswagen</TD><TD>Convertibles</TD><TD>Beetle Convertible</TD></TR><TR><TD align="right" height="20">100388</TD><TD>Volkswagen</TD><TD>SUVS</TD><TD>Tiguan</TD></TR><TR><TD align="right" height="20">100388</TD><TD>Volkswagen</TD><TD>SUVS</TD><TD>Atlas</TD></TR><TR><TD align="right" height="20">100879</TD><TD>BMW</TD><TD>Sedans</TD><TD>3 Series Gran Turismo</TD></TR><TR><TD align="right" height="20">100879</TD><TD>BMW</TD><TD>Coupes</TD><TD>2 Series Coupe</TD></TR><TR><TD align="right" height="20">100879</TD><TD>BMW</TD><TD>Convertibles</TD><TD>4 Series Convertible</TD></TR><TR><TD align="right" height="20">100879</TD><TD>BMW</TD><TD>Sedans</TD><TD>6 Series Gran Turismo</TD></TR><TR><TD align="right" height="20">100879</TD><TD>Volkswagen</TD><TD>Compacts</TD><TD>GolfGTI</TD></TR><TR><TD align="right" height="20">100879</TD><TD>Volkswagen</TD><TD>Sedans</TD><TD>Passat</TD></TR><TR><TD align="right" height="20">100879</TD><TD>BMW</TD><TD>Coupes</TD><TD>6 Series Gran Coupe</TD></TR><TR><TD align="right" height="20">100879</TD><TD>BMW</TD><TD>Convertibles</TD><TD>2 Series Convertible</TD></TR><TR><TD align="right" height="20">100879</TD><TD>BMW</TD><TD>SAVs</TD><TD>X4 Sports Activity Coupe</TD></TR><TR><TD align="right" height="20">100879</TD><TD>BMW</TD><TD>Sedans</TD><TD>3 Series Sedan</TD></TR><TR><TD align="right" height="20">100890</TD><TD>BMW</TD><TD>Sedans</TD><TD>3 Series Sports Wagon</TD></TR><TR><TD align="right" height="20">100890</TD><TD>BMW</TD><TD>Convertibles</TD><TD>BMW i8 Roadster</TD></TR><TR><TD align="right" height="20">100890</TD><TD>BMW</TD><TD>Sedans</TD><TD>M5 Sedan</TD></TR><TR><TD align="right" height="20">100890</TD><TD>Volkswagen</TD><TD>Compacts</TD><TD>Golf R</TD></TR><TR><TD align="right" height="20">100890</TD><TD>Volkswagen</TD><TD>Wagons</TD><TD>Golf SportWagen</TD></TR><TR><TD align="right" height="20">100923</TD><TD>Volkswagen</TD><TD>Sedans</TD><TD>Jetta</TD></TR><TR><TD align="right" height="20">100923</TD><TD>BMW</TD><TD>Coupes</TD><TD>ALPINA B6</TD></TR><TR><TD align="right" height="20">100923</TD><TD>BMW</TD><TD>SAVs</TD><TD>X1 Sports Activity Vehicle</TD></TR><TR><TD align="right" height="20">100923</TD><TD>Volkswagen</TD><TD>Wagons</TD><TD>Golf Alltrack</TD></TR><TR><TD align="right" height="20">100923</TD><TD>BMW</TD><TD>Coupes</TD><TD>M6 Gran Coupe</TD></TR><TR><TD align="right" height="20">100930</TD><TD>BMW</TD><TD>Coupes</TD><TD>BMW i8</TD></TR><TR><TD align="right" height="20">100930</TD><TD>BMW</TD><TD>Coupes</TD><TD>4 Series Gran Coupe</TD></TR><TR><TD align="right" height="20">100930</TD><TD>BMW</TD><TD>Coupes</TD><TD>M4 Coupe</TD></TR><TR><TD align="right" height="20">100930</TD><TD>BMW</TD><TD>Coupes</TD><TD>4 Series Coupe</TD></TR><TR><TD align="right" height="20">100930</TD><TD>BMW</TD><TD>Sedans</TD><TD>BMW i3</TD></TR><TR><TD align="right" height="20">100930</TD><TD>Volkswagen</TD><TD>Compacts</TD><TD>e-Golf</TD></TR><TR><TD align="right" height="20">100930</TD><TD>BMW</TD><TD>Sedans</TD><TD>5 Series Sedan</TD></TR><TR><TD align="right" height="20">100930</TD><TD>BMW</TD><TD>Coupes</TD><TD>8 Series Coupe</TD></TR><TR><TD align="right" height="20">100930</TD><TD>BMW</TD><TD>SAVs</TD><TD>X5 M Sports Activity Vehicle</TD></TR><TR><TD align="right" height="20">100930</TD><TD>BMW</TD><TD>SAVs</TD><TD>X6 Sports Activity Coupe</TD></TR><TR><TD align="right" height="20">100936</TD><TD>BMW</TD><TD>SAVs</TD><TD>X6 M Sports Activity Coupe</TD></TR><TR><TD align="right" height="20">100936</TD><TD>BMW</TD><TD>Sedans</TD><TD>ALPINA B7</TD></TR><TR><TD align="right" height="20">100936</TD><TD>BMW</TD><TD>Sedans</TD><TD>M3 Sedan</TD></TR><TR><TD align="right" height="20">100936</TD><TD>Volkswagen</TD><TD>Compacts</TD><TD>Golf</TD></TR><TR><TD align="right" height="20">100936</TD><TD>BMW</TD><TD>SAVs</TD><TD>X3 Sports Activity Vehicle</TD></TR></TBODY></TABLE></BODY></HTML> Fri, 21 Sep 2018 02:30:00 GMT Anonymous 2018-09-21T02:30:00Z Map product name https://community.qlik.com/t5/App-Development/Map-product-name/m-p/95189#M6337 <HTML><HEAD></HEAD><BODY><P>I want to use ApplyMap with a concatenated field but this is the script editor error message I get.</P><P></P><P class="headline undefined" style="padding: 0px 10px 0px 70px; font-weight: bolder; color: #595959; font-family: 'Courier New'; font-size: 13px;">Started loading data</P><P style="padding: 0px 10px 0px 70px; color: #595959; font-family: 'Courier New'; font-size: 13px;">MapIt << Sheet2 Lines fetched: 44</P><P class="headline edc_error" style="padding: 0px 10px 0px 70px; font-weight: bolder; color: #595959; font-family: 'Courier New'; font-size: 13px; background: rgba(255, 38, 38, 0.2);">The following error occurred:</P><P class="edc_error" style="padding: 0px 10px 0px 70px; color: #595959; font-family: 'Courier New'; font-size: 13px; background: rgba(255, 38, 38, 0.2);">Field 'Key Field' not found</P><P class="headline edc_error" style="padding: 0px 10px 0px 70px; font-weight: bolder; color: #595959; font-family: 'Courier New'; font-size: 13px; background: rgba(255, 38, 38, 0.2);">The error occurred here:</P><P class="edc_error" style="padding: 0px 10px 0px 70px; color: #595959; font-family: 'Courier New'; font-size: 13px; background: rgba(255, 38, 38, 0.2);">?</P><P class="headline undefined" style="padding: 0px 10px 0px 70px; font-weight: bolder; color: #595959; font-family: 'Courier New'; font-size: 13px;">Data has not been loaded. Please correct the error and try loading again.</P><P></P><P>This is my script.</P><P></P><P style="padding-left: 60px;">MapIt:</P><P style="padding-left: 60px;">Mapping Load</P><P style="padding-left: 60px;">[Order Number]&[Brand]&[Motor Type] as "Key Field",</P><P style="padding-left: 60px;">Product</P><P style="padding-left: 60px;">FROM [lib://Motors/Motors.xlsx]</P><P style="padding-left: 60px;">(ooxml, embedded labels, table is Sheet2);</P><P style="padding-left: 60px;"></P><P style="padding-left: 60px;">Details:</P><P style="padding-left: 60px;">LOAD</P><P style="padding-left: 60px;">    "Order Number",</P><P style="padding-left: 60px;">    Brand,</P><P style="padding-left: 60px;">    "Motor Type",</P><P style="padding-left: 60px;">    [Order Number]&[Brand]&[Motor Type] as "Key Field",</P><P style="padding-left: 60px;">    ApplyMap('MapIt', "Key Field", null()) as ProductName</P><P></P><P style="padding-left: 60px;">FROM [lib://Motors/Motors.xlsx]</P><P style="padding-left: 60px;">(ooxml, embedded labels, table is Sheet1);</P><P style="padding-left: 60px;"></P><P>This is from Sheet1</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 282px;"><TBODY><TR><TD height="20" width="98">Order Number</TD><TD width="98">Brand</TD><TD width="86">Motor Type</TD></TR><TR><TD align="right" height="20">100388</TD><TD>Volkswagen</TD><TD>Compacts</TD></TR><TR><TD align="right" height="20">100388</TD><TD>BMW</TD><TD>SAVs</TD></TR><TR><TD align="right" height="20">100388</TD><TD>BMW</TD><TD>Sedans</TD></TR><TR><TD align="right" height="20">100388</TD><TD>BMW</TD><TD>Coupes</TD></TR><TR><TD align="right" height="20">100388</TD><TD>BMW</TD><TD>Convertibles</TD></TR><TR><TD align="right" height="20">100388</TD><TD>BMW</TD><TD>SAVs</TD></TR><TR><TD align="right" height="20">100388</TD><TD>Volkswagen</TD><TD>Convertibles</TD></TR><TR><TD align="right" height="20">100388</TD><TD>Volkswagen</TD><TD>SUVS</TD></TR><TR><TD align="right" height="20">100388</TD><TD>Volkswagen</TD><TD>SUVS</TD></TR><TR><TD align="right" height="20">100879</TD><TD>BMW</TD><TD>Sedans</TD></TR><TR><TD align="right" height="20">100879</TD><TD>BMW</TD><TD>Coupes</TD></TR><TR><TD align="right" height="20">100879</TD><TD>BMW</TD><TD>Convertibles</TD></TR><TR><TD align="right" height="20">100879</TD><TD>BMW</TD><TD>Sedans</TD></TR><TR><TD align="right" height="20">100879</TD><TD>Volkswagen</TD><TD>Compacts</TD></TR><TR><TD align="right" height="20">100879</TD><TD>Volkswagen</TD><TD>Sedans</TD></TR><TR><TD align="right" height="20">100879</TD><TD>BMW</TD><TD>Coupes</TD></TR><TR><TD align="right" height="20">100879</TD><TD>BMW</TD><TD>Convertibles</TD></TR><TR><TD align="right" height="20">100879</TD><TD>BMW</TD><TD>SAVs</TD></TR><TR><TD align="right" height="20">100879</TD><TD>BMW</TD><TD>Sedans</TD></TR><TR><TD align="right" height="20">100890</TD><TD>BMW</TD><TD>Sedans</TD></TR><TR><TD align="right" height="20">100890</TD><TD>BMW</TD><TD>Convertibles</TD></TR><TR><TD align="right" height="20">100890</TD><TD>BMW</TD><TD>Sedans</TD></TR><TR><TD align="right" height="20">100890</TD><TD>Volkswagen</TD><TD>Compacts</TD></TR><TR><TD align="right" height="20">100890</TD><TD>Volkswagen</TD><TD>Wagons</TD></TR><TR><TD align="right" height="20">100923</TD><TD>Volkswagen</TD><TD>Sedans</TD></TR><TR><TD align="right" height="20">100923</TD><TD>BMW</TD><TD>Coupes</TD></TR><TR><TD align="right" height="20">100923</TD><TD>BMW</TD><TD>SAVs</TD></TR><TR><TD align="right" height="20">100923</TD><TD>Volkswagen</TD><TD>Wagons</TD></TR><TR><TD align="right" height="20">100923</TD><TD>BMW</TD><TD>Coupes</TD></TR><TR><TD align="right" height="20">100930</TD><TD>BMW</TD><TD>Coupes</TD></TR><TR><TD align="right" height="20">100930</TD><TD>BMW</TD><TD>Coupes</TD></TR><TR><TD align="right" height="20">100930</TD><TD>BMW</TD><TD>Coupes</TD></TR><TR><TD align="right" height="20">100930</TD><TD>BMW</TD><TD>Coupes</TD></TR><TR><TD align="right" height="20">100930</TD><TD>BMW</TD><TD>Sedans</TD></TR><TR><TD align="right" height="20">100930</TD><TD>Volkswagen</TD><TD>Compacts</TD></TR><TR><TD align="right" height="20">100930</TD><TD>BMW</TD><TD>Sedans</TD></TR><TR><TD align="right" height="20">100930</TD><TD>BMW</TD><TD>Coupes</TD></TR><TR><TD align="right" height="20">100930</TD><TD>BMW</TD><TD>SAVs</TD></TR><TR><TD align="right" height="20">100930</TD><TD>BMW</TD><TD>SAVs</TD></TR><TR><TD align="right" height="20">100936</TD><TD>BMW</TD><TD>SAVs</TD></TR><TR><TD align="right" height="20">100936</TD><TD>BMW</TD><TD>Sedans</TD></TR><TR><TD align="right" height="20">100936</TD><TD>BMW</TD><TD>Sedans</TD></TR><TR><TD align="right" height="20">100936</TD><TD>Volkswagen</TD><TD>Compacts</TD></TR><TR><TD align="right" height="20">100936</TD><TD>BMW</TD><TD>SAVs</TD></TR></TBODY></TABLE><P class="headline undefined" style="padding: 0 10px; font-weight: bolder; color: #595959; font-family: 'Courier New'; font-size: 13px;"></P><P class="headline undefined" style="padding: 0 10px; font-weight: bolder; color: #595959; font-family: 'Courier New'; font-size: 13px;"><SPAN style="font-size: 13.3333px; font-family: arial, helvetica, sans-serif;">This is from Sheet2</SPAN></P><P class="headline undefined" style="padding: 0 10px; font-weight: bolder; color: #595959; font-family: 'Courier New'; font-size: 13px;"></P><P>     </P><TABLE border="0" cellpadding="0" cellspacing="0" width="449"><TBODY><TR><TD height="20" width="98">Order Number</TD><TD width="82">Brand</TD><TD width="86">Motor Type</TD><TD width="183">Product</TD></TR><TR><TD align="right" height="20">100388</TD><TD>Volkswagen</TD><TD>Compacts</TD><TD>Beetle</TD></TR><TR><TD align="right" height="20">100388</TD><TD>BMW</TD><TD>SAVs</TD><TD>X5 Sports Activity Vehicle</TD></TR><TR><TD align="right" height="20">100388</TD><TD>BMW</TD><TD>Sedans</TD><TD>7 Series Sedan</TD></TR><TR><TD align="right" height="20">100388</TD><TD>BMW</TD><TD>Coupes</TD><TD>M2 Competition Coupe</TD></TR><TR><TD align="right" height="20">100388</TD><TD>BMW</TD><TD>Convertibles</TD><TD>M4 Convertible</TD></TR><TR><TD align="right" height="20">100388</TD><TD>BMW</TD><TD>SAVs</TD><TD>X2 Sports Activity Coupe</TD></TR><TR><TD align="right" height="20">100388</TD><TD>Volkswagen</TD><TD>Convertibles</TD><TD>Beetle Convertible</TD></TR><TR><TD align="right" height="20">100388</TD><TD>Volkswagen</TD><TD>SUVS</TD><TD>Tiguan</TD></TR><TR><TD align="right" height="20">100388</TD><TD>Volkswagen</TD><TD>SUVS</TD><TD>Atlas</TD></TR><TR><TD align="right" height="20">100879</TD><TD>BMW</TD><TD>Sedans</TD><TD>3 Series Gran Turismo</TD></TR><TR><TD align="right" height="20">100879</TD><TD>BMW</TD><TD>Coupes</TD><TD>2 Series Coupe</TD></TR><TR><TD align="right" height="20">100879</TD><TD>BMW</TD><TD>Convertibles</TD><TD>4 Series Convertible</TD></TR><TR><TD align="right" height="20">100879</TD><TD>BMW</TD><TD>Sedans</TD><TD>6 Series Gran Turismo</TD></TR><TR><TD align="right" height="20">100879</TD><TD>Volkswagen</TD><TD>Compacts</TD><TD>GolfGTI</TD></TR><TR><TD align="right" height="20">100879</TD><TD>Volkswagen</TD><TD>Sedans</TD><TD>Passat</TD></TR><TR><TD align="right" height="20">100879</TD><TD>BMW</TD><TD>Coupes</TD><TD>6 Series Gran Coupe</TD></TR><TR><TD align="right" height="20">100879</TD><TD>BMW</TD><TD>Convertibles</TD><TD>2 Series Convertible</TD></TR><TR><TD align="right" height="20">100879</TD><TD>BMW</TD><TD>SAVs</TD><TD>X4 Sports Activity Coupe</TD></TR><TR><TD align="right" height="20">100879</TD><TD>BMW</TD><TD>Sedans</TD><TD>3 Series Sedan</TD></TR><TR><TD align="right" height="20">100890</TD><TD>BMW</TD><TD>Sedans</TD><TD>3 Series Sports Wagon</TD></TR><TR><TD align="right" height="20">100890</TD><TD>BMW</TD><TD>Convertibles</TD><TD>BMW i8 Roadster</TD></TR><TR><TD align="right" height="20">100890</TD><TD>BMW</TD><TD>Sedans</TD><TD>M5 Sedan</TD></TR><TR><TD align="right" height="20">100890</TD><TD>Volkswagen</TD><TD>Compacts</TD><TD>Golf R</TD></TR><TR><TD align="right" height="20">100890</TD><TD>Volkswagen</TD><TD>Wagons</TD><TD>Golf SportWagen</TD></TR><TR><TD align="right" height="20">100923</TD><TD>Volkswagen</TD><TD>Sedans</TD><TD>Jetta</TD></TR><TR><TD align="right" height="20">100923</TD><TD>BMW</TD><TD>Coupes</TD><TD>ALPINA B6</TD></TR><TR><TD align="right" height="20">100923</TD><TD>BMW</TD><TD>SAVs</TD><TD>X1 Sports Activity Vehicle</TD></TR><TR><TD align="right" height="20">100923</TD><TD>Volkswagen</TD><TD>Wagons</TD><TD>Golf Alltrack</TD></TR><TR><TD align="right" height="20">100923</TD><TD>BMW</TD><TD>Coupes</TD><TD>M6 Gran Coupe</TD></TR><TR><TD align="right" height="20">100930</TD><TD>BMW</TD><TD>Coupes</TD><TD>BMW i8</TD></TR><TR><TD align="right" height="20">100930</TD><TD>BMW</TD><TD>Coupes</TD><TD>4 Series Gran Coupe</TD></TR><TR><TD align="right" height="20">100930</TD><TD>BMW</TD><TD>Coupes</TD><TD>M4 Coupe</TD></TR><TR><TD align="right" height="20">100930</TD><TD>BMW</TD><TD>Coupes</TD><TD>4 Series Coupe</TD></TR><TR><TD align="right" height="20">100930</TD><TD>BMW</TD><TD>Sedans</TD><TD>BMW i3</TD></TR><TR><TD align="right" height="20">100930</TD><TD>Volkswagen</TD><TD>Compacts</TD><TD>e-Golf</TD></TR><TR><TD align="right" height="20">100930</TD><TD>BMW</TD><TD>Sedans</TD><TD>5 Series Sedan</TD></TR><TR><TD align="right" height="20">100930</TD><TD>BMW</TD><TD>Coupes</TD><TD>8 Series Coupe</TD></TR><TR><TD align="right" height="20">100930</TD><TD>BMW</TD><TD>SAVs</TD><TD>X5 M Sports Activity Vehicle</TD></TR><TR><TD align="right" height="20">100930</TD><TD>BMW</TD><TD>SAVs</TD><TD>X6 Sports Activity Coupe</TD></TR><TR><TD align="right" height="20">100936</TD><TD>BMW</TD><TD>SAVs</TD><TD>X6 M Sports Activity Coupe</TD></TR><TR><TD align="right" height="20">100936</TD><TD>BMW</TD><TD>Sedans</TD><TD>ALPINA B7</TD></TR><TR><TD align="right" height="20">100936</TD><TD>BMW</TD><TD>Sedans</TD><TD>M3 Sedan</TD></TR><TR><TD align="right" height="20">100936</TD><TD>Volkswagen</TD><TD>Compacts</TD><TD>Golf</TD></TR><TR><TD align="right" height="20">100936</TD><TD>BMW</TD><TD>SAVs</TD><TD>X3 Sports Activity Vehicle</TD></TR></TBODY></TABLE></BODY></HTML> Fri, 21 Sep 2018 02:30:00 GMT https://community.qlik.com/t5/App-Development/Map-product-name/m-p/95189#M6337 Anonymous 2018-09-21T02:30:00Z Re: Map product name https://community.qlik.com/t5/App-Development/Map-product-name/m-p/95190#M6338 <HTML><HEAD></HEAD><BODY><P>Hi John,</P><P></P><P>At that step that field is not exist, change it to the definition.</P><P></P><P>Try this:</P><P></P><P style="padding: 0 0 0 60px; font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Details:</P><P style="padding: 0 0 0 60px; font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">LOAD</P><P style="padding: 0 0 0 60px; font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">    "Order Number",</P><P style="padding: 0 0 0 60px; font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">    Brand,</P><P style="padding: 0 0 0 60px; font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">    "Motor Type",</P><P style="padding: 0 0 0 60px; font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">    [Order Number]&[Brand]&[Motor Type] as "Key Field",</P><P style="padding: 0 0 0 60px; font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">    ApplyMap('MapIt', <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12px;"><STRONG>[Order Number]&[Brand]&[Motor Type]</STRONG></SPAN>, null()) as ProductName</P><P></P><P style="padding: 0 0 0 60px; font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">FROM [lib://Motors/Motors.xlsx]</P><P style="padding: 0 0 0 60px; font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">(ooxml, embedded labels, table is Sheet1);</P><P style="padding: 0 0 0 60px; font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="padding: 0 0 0 60px; font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">G.</P></BODY></HTML> Fri, 21 Sep 2018 21:44:25 GMT https://community.qlik.com/t5/App-Development/Map-product-name/m-p/95190#M6338 undergrinder 2018-09-21T21:44:25Z