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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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.