Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Author

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.