topic Re: Format Date When Loading in QlikView https://community.qlik.com/t5/QlikView/Format-Date-When-Loading/m-p/29727#M773296 <HTML><HEAD></HEAD><BODY><P>It looks like you are specifying two columns. One with an abbreviation of the month name "In" and one with a number called "Out". </P><P></P><P>I don't think you need the mapping load, unless there is another reason for it.</P><P></P><P>I removed the mapping load and ApplyMap function and it loaded fine based on the inline data.</P><P></P><P>Map_Months:</P><P></P><P></P><P>LOAD * INLINE [</P><P></P><P></P><P>In,Out</P><P></P><P></P><P>Jan,01</P><P></P><P></P><P>Feb,02</P><P></P><P></P><P>Mar,03</P><P></P><P></P><P>Apr,04</P><P></P><P></P><P>May,05</P><P></P><P></P><P>Jun,06</P><P></P><P></P><P>Jul,07</P><P></P><P></P><P>Aug,08</P><P></P><P></P><P>Sep,09</P><P></P><P></P><P>Oct,10</P><P></P><P></P><P>Nov,11</P><P></P><P></P><P>Dec,12</P><P>];</P><P></P><P></P><P>Table1:</P><P>LOAD dual(Month('Map_Months')) AS Month</P></BODY></HTML> Mon, 14 May 2018 20:07:50 GMT Anonymous 2018-05-14T20:07:50Z Format Date When Loading https://community.qlik.com/t5/QlikView/Format-Date-When-Loading/m-p/29725#M773294 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>How do I get the month function to accept only the month number when loading in data?</P><P></P><P>Here is part of my script:</P><P></P><P>Map_Months:</P><P></P><P>MAPPING LOAD * INLINE [</P><P></P><P>In,Out</P><P></P><P>Jan,01</P><P></P><P>Feb,02</P><P></P><P>Mar,03</P><P></P><P>Apr,04</P><P></P><P>May,05</P><P></P><P>Jun,06</P><P></P><P>Jul,07</P><P></P><P>Aug,08</P><P></P><P>Sep,09</P><P></P><P>Oct,10</P><P></P><P>Nov,11</P><P></P><P>Dec,12</P><P>];</P><P></P><P></P><P>Table1:</P><P>LOAD Month(ApplyMap('Map_Months',Month)) AS Month</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Format-Date-When-Loading/m-p/29725#M773294 Anonymous 2020-11-25T16:16:04Z Re: Format Date When Loading https://community.qlik.com/t5/QlikView/Format-Date-When-Loading/m-p/29726#M773295 <HTML><HEAD></HEAD><BODY><P>Try without the Month() function</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>Table1:</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>LOAD ApplyMap('Map_Months', Month) as Month</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">or this</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>Table1:</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>LOAD ApplyMap('Map_Months', Month(Date#(Month, 'MMM'))) as Month</STRONG></P></BODY></HTML> Mon, 14 May 2018 19:51:28 GMT https://community.qlik.com/t5/QlikView/Format-Date-When-Loading/m-p/29726#M773295 sunny_talwar 2018-05-14T19:51:28Z Re: Format Date When Loading https://community.qlik.com/t5/QlikView/Format-Date-When-Loading/m-p/29727#M773296 <HTML><HEAD></HEAD><BODY><P>It looks like you are specifying two columns. One with an abbreviation of the month name "In" and one with a number called "Out". </P><P></P><P>I don't think you need the mapping load, unless there is another reason for it.</P><P></P><P>I removed the mapping load and ApplyMap function and it loaded fine based on the inline data.</P><P></P><P>Map_Months:</P><P></P><P></P><P>LOAD * INLINE [</P><P></P><P></P><P>In,Out</P><P></P><P></P><P>Jan,01</P><P></P><P></P><P>Feb,02</P><P></P><P></P><P>Mar,03</P><P></P><P></P><P>Apr,04</P><P></P><P></P><P>May,05</P><P></P><P></P><P>Jun,06</P><P></P><P></P><P>Jul,07</P><P></P><P></P><P>Aug,08</P><P></P><P></P><P>Sep,09</P><P></P><P></P><P>Oct,10</P><P></P><P></P><P>Nov,11</P><P></P><P></P><P>Dec,12</P><P>];</P><P></P><P></P><P>Table1:</P><P>LOAD dual(Month('Map_Months')) AS Month</P></BODY></HTML> Mon, 14 May 2018 20:07:50 GMT https://community.qlik.com/t5/QlikView/Format-Date-When-Loading/m-p/29727#M773296 Anonymous 2018-05-14T20:07:50Z