Discussion Board for collaboration on QlikView Scripting.
I loading a shipping table. There are few fields in shipping table that stores information as '0' and '1'. I would like to rename '0' as 'No' and '1' as 'Yes'.
i.e. Field Name - Shipped: Rename '0' as 'Not Shipped' and '1' as 'Shipped'
Go to Solution.
if(Shipped,'Shipped','Not Shipped') as Shipped,
or using a mapping table:
MAPPING LOAD * INLINE [
applymap('MAP',Shipped,'unknown status') as Shipped,
Perhaps more than the OP asked for, but I like to load or map as a dual. That way you get "Yes" / "No" in display fields (like listboxes and table columns) but still retain the the ability to use expressions like
Create the mapping table like this:
LOAD from, dual(to,from) INLINE [
Map Shipped USING YesNoMap;