Discussion board where members can get started with QlikView.
I want to load the following
* INLINE [StoreKeyOther, StoreType.1, KA2, BA15,CornerStorkBabyGifts18,TooCuteBabyGifts31,MyWeddingFavors33,FavorAffair38,MyQuinceFavors43,KateaspenUK45,TheAspenShops46,TheAspenShops115,TheAspenShops];
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.
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.