Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Load question

I want to load the following

LOAD

* INLINE [

StoreKeyOther, StoreType.

1, KA

2, BA

15,CornerStorkBabyGifts

18,TooCuteBabyGifts

31,MyWeddingFavors

33,FavorAffair

38,MyQuinceFavors

43,KateaspenUK

45,TheAspenShops

46,TheAspenShops

115,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.

1 Reply
Not applicable

Re: Load question

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.