Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN 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.