topic Mapping table and blank fields in QlikView https://community.qlik.com/t5/QlikView/Mapping-table-and-blank-fields/m-p/1088119#M927343 <HTML><HEAD></HEAD><BODY><P>I am trying to use a mapping table to decode user entered data into categories.&nbsp; If the user fails to enter any data, it needs to map to 'Unknown'.&nbsp; Try as I might, I cannot get any value mapped to a blank field.&nbsp; I have tried:</P><P></P><P>null(),unknown</P><P>'',unknown&nbsp;&nbsp;&nbsp;&nbsp; (single quotes with nothing in between)</P><P>"",unknown&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (double quotes with nothing in between)</P><P>,unknown&nbsp;&nbsp;&nbsp;&nbsp; (nothing in front of the comma)</P><P></P><P>Is it possible to map a blank field at all?</P><P>If the user enters at least a blanks space, the mapping table picks that up just fine.</P><P></P><P>If I load the map table as a stand alone table and do a join on this field, it works, but I would prefer to use a map table.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT dwfiv327 2020-11-25T16:16:04Z Mapping table and blank fields https://community.qlik.com/t5/QlikView/Mapping-table-and-blank-fields/m-p/1088119#M927343 <HTML><HEAD></HEAD><BODY><P>I am trying to use a mapping table to decode user entered data into categories.&nbsp; If the user fails to enter any data, it needs to map to 'Unknown'.&nbsp; Try as I might, I cannot get any value mapped to a blank field.&nbsp; I have tried:</P><P></P><P>null(),unknown</P><P>'',unknown&nbsp;&nbsp;&nbsp;&nbsp; (single quotes with nothing in between)</P><P>"",unknown&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (double quotes with nothing in between)</P><P>,unknown&nbsp;&nbsp;&nbsp;&nbsp; (nothing in front of the comma)</P><P></P><P>Is it possible to map a blank field at all?</P><P>If the user enters at least a blanks space, the mapping table picks that up just fine.</P><P></P><P>If I load the map table as a stand alone table and do a join on this field, it works, but I would prefer to use a map table.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Mapping-table-and-blank-fields/m-p/1088119#M927343 dwfiv327 2020-11-25T16:16:04Z Re: Mapping table and blank fields https://community.qlik.com/t5/QlikView/Mapping-table-and-blank-fields/m-p/1088120#M927344 <HTML><HEAD></HEAD><BODY><P>chk dis</P><P></P><P><A href="https://community.qlik.com/message/771978">Fill empty value with mapping</A></P></BODY></HTML> Tue, 29 Mar 2016 16:47:11 GMT https://community.qlik.com/t5/QlikView/Mapping-table-and-blank-fields/m-p/1088120#M927344 Chanty4u 2016-03-29T16:47:11Z