topic Mapping table help in QlikView https://community.qlik.com/t5/QlikView/Mapping-table-help/m-p/415322#M154496 <HTML><HEAD></HEAD><BODY><P>This seems easy. I am trying to map a field from a table to another based on a date field and a timestamp field. I think the issue I am having is in the formatting the mapping fields. Please see attached. Thanks for the help.</P></BODY></HTML> Thu, 07 Mar 2013 02:30:06 GMT regowins 2013-03-07T02:30:06Z Mapping table help https://community.qlik.com/t5/QlikView/Mapping-table-help/m-p/415322#M154496 <HTML><HEAD></HEAD><BODY><P>This seems easy. I am trying to map a field from a table to another based on a date field and a timestamp field. I think the issue I am having is in the formatting the mapping fields. Please see attached. Thanks for the help.</P></BODY></HTML> Thu, 07 Mar 2013 02:30:06 GMT https://community.qlik.com/t5/QlikView/Mapping-table-help/m-p/415322#M154496 regowins 2013-03-07T02:30:06Z Re: Mapping table help https://community.qlik.com/t5/QlikView/Mapping-table-help/m-p/415323#M154497 <HTML><HEAD></HEAD><BODY><P> <SPAN style="color: black; font-family: &amp;quot;Arial&amp;quot;,&amp;quot;sans-serif&amp;quot;; font-size: 10pt; mso-themecolor: text1;">Ok, I think I figured it out. As I guessed it was a formatting issue. To</SPAN><SPAN style=": ; mso-bidi-language: AR-SA; mso-bidi-font-family: &amp;quot; mso-fareast-language: EN-US; sans-serif&amp;quot: ; ,&amp;quot: ; color: black; font-size: 11pt; mso-ansi-language: EN-US; Times New Roman&amp;quot: ; mso-themecolor: text1; font-family: &amp;quot; mso-fareast-theme-font: minor-latin; mso-fareast-font-family: Calibri; Calibri&amp;quot: ;"> match the 2 dates I converted both to numeric. For the timestamp, I used floor() to eliminate the fractional part</SPAN></P></BODY></HTML> Thu, 07 Mar 2013 03:15:19 GMT https://community.qlik.com/t5/QlikView/Mapping-table-help/m-p/415323#M154497 regowins 2013-03-07T03:15:19Z