topic Load question in QlikView https://community.qlik.com/t5/QlikView/Load-question/m-p/451748#M1154016 <HTML><HEAD></HEAD><BODY><P>I want to load the following</P><P></P><P>LOAD</P><P><SPAN style="font-size: 8pt;"> * </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">INLINE</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">[<BR /><BR />StoreKeyOther, StoreType.<BR /><BR />1, KA<BR /><BR />2, BA<BR /><BR />15,CornerStorkBabyGifts<BR /><BR />18,TooCuteBabyGifts<BR /><BR />31,MyWeddingFavors<BR /><BR />33,FavorAffair<BR /><BR />38,MyQuinceFavors<BR /><BR />43,KateaspenUK<BR /><BR />45,TheAspenShops<BR /><BR />46,TheAspenShops<BR /><BR />115,TheAspenShops<BR /><BR />]</SPAN><SPAN style="font-size: 8pt;">; </SPAN></P><P></P><P><SPAN style="font-size: 8pt;">However, we might add a new StoreKeyOther and I won't be aware of it, is there a way to make anything that is not on the load list to default to "NA" or something to that effect.</SPAN></P></BODY></HTML> Mon, 18 Mar 2013 20:34:18 GMT 2013-03-18T20:34:18Z Load question https://community.qlik.com/t5/QlikView/Load-question/m-p/451748#M1154016 <HTML><HEAD></HEAD><BODY><P>I want to load the following</P><P></P><P>LOAD</P><P><SPAN style="font-size: 8pt;"> * </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">INLINE</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">[<BR /><BR />StoreKeyOther, StoreType.<BR /><BR />1, KA<BR /><BR />2, BA<BR /><BR />15,CornerStorkBabyGifts<BR /><BR />18,TooCuteBabyGifts<BR /><BR />31,MyWeddingFavors<BR /><BR />33,FavorAffair<BR /><BR />38,MyQuinceFavors<BR /><BR />43,KateaspenUK<BR /><BR />45,TheAspenShops<BR /><BR />46,TheAspenShops<BR /><BR />115,TheAspenShops<BR /><BR />]</SPAN><SPAN style="font-size: 8pt;">; </SPAN></P><P></P><P><SPAN style="font-size: 8pt;">However, we might add a new StoreKeyOther and I won't be aware of it, is there a way to make anything that is not on the load list to default to "NA" or something to that effect.</SPAN></P></BODY></HTML> Mon, 18 Mar 2013 20:34:18 GMT https://community.qlik.com/t5/QlikView/Load-question/m-p/451748#M1154016 2013-03-18T20:34:18Z Re: Load question https://community.qlik.com/t5/QlikView/Load-question/m-p/451749#M1154017 <HTML><HEAD></HEAD><BODY><P>Yes. You can use a Mapping Load and then refer to the field using ApplyMap(). This way you can set the missing items to NA.</P></BODY></HTML> Mon, 18 Mar 2013 21:15:09 GMT https://community.qlik.com/t5/QlikView/Load-question/m-p/451749#M1154017 2013-03-18T21:15:09Z