topic Transforming Data in QlikView https://community.qlik.com/t5/QlikView/Transforming-Data/m-p/52796#M791009 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P></P><P>Quick question, I normally received data on my email everyday and is on this format like below:</P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Account number: 122225</SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Date: 09/01/2018</SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Method of transaction: XXX Credit </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Amount : 233610,97 </SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Account number: 554555</SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Date: 02/11/2017</SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Method of transaction: XXX Credit</SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Amount: 155403,09</SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Account number: 678919</SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Date: 16/10/2017</SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Method of transaction: XXX Credit</SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Amount: 151698,36</SPAN></P><P></P><P></P><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Expected output on my Qlikview application is</SPAN></P><P></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0" style="padding: 0px 5.4pt;" width="0"><TBODY><TR><TD nowrap="nowrap" style="padding: 0px 5.4pt; border: #000000; border-image: none;" valign="bottom" width="116"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: black; font-size: 12pt; font-family: Calibri;">Account number</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0px 5.4pt; border: #000000; border-image: none;" valign="bottom" width="85"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: black; font-size: 12pt; font-family: Calibri;">Date</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0px 5.4pt; border: #000000; border-image: none;" valign="bottom" width="152"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: black; font-size: 12pt; font-family: Calibri;">Method of transaction</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0px 5.4pt; border: #000000; border-image: none;" valign="bottom" width="80"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: black; font-size: 12pt; font-family: Calibri;">Amount</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0px 5.4pt; border: #000000; border-image: none;" valign="bottom" width="116"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P align="right" style="text-align: right;"><SPAN style="color: black; font-size: 12pt; font-family: Calibri;">122225</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0px 5.4pt; border: #000000; border-image: none;" valign="bottom" width="85"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: black; font-size: 12pt; font-family: Calibri;">09/01/2018</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0px 5.4pt; border: #000000; border-image: none;" valign="bottom" width="152"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: black; font-size: 12pt; font-family: Calibri;"> XXX Credit</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0px 5.4pt; border: #000000; border-image: none;" valign="bottom" width="80"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: black; font-size: 12pt; font-family: Calibri;">33610,97</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0px 5.4pt; border: #000000; border-image: none;" valign="bottom" width="116"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P align="right" style="text-align: right;"><SPAN style="color: black; font-size: 12pt; font-family: Calibri;">554555</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0px 5.4pt; border: #000000; border-image: none;" valign="bottom" width="85"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: black; font-size: 12pt; font-family: Calibri;">02/11/2017</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0px 5.4pt; border: #000000; border-image: none;" valign="bottom" width="152"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: black; font-size: 12pt; font-family: Calibri;"> XXX Credit</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0px 5.4pt; border: #000000; border-image: none;" width="80"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: black; font-size: 12pt; font-family: Calibri;">155403,09</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0px 5.4pt; border: #000000; border-image: none;" valign="bottom" width="116"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P align="right" style="text-align: right;"><SPAN style="color: black; font-size: 12pt; font-family: Calibri;">678919</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0px 5.4pt; border: #000000; border-image: none;" valign="bottom" width="85"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: black; font-size: 12pt; font-family: Calibri;">16/10/2017</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0px 5.4pt; border: #000000; border-image: none;" valign="bottom" width="152"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: black; font-size: 12pt; font-family: Calibri;"> XXX Credit</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0px 5.4pt; border: #000000; border-image: none;" valign="bottom" width="80"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: black; font-size: 12pt; font-family: Calibri;">151698,36</SPAN></P></TD></TR></TBODY></TABLE><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><P></P><P>Your assistance will be highly appreciated</P><P></P><P></P><P></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT zwyne 2020-11-25T16:16:04Z Transforming Data https://community.qlik.com/t5/QlikView/Transforming-Data/m-p/52796#M791009 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P></P><P>Quick question, I normally received data on my email everyday and is on this format like below:</P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Account number: 122225</SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Date: 09/01/2018</SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Method of transaction: XXX Credit </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Amount : 233610,97 </SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Account number: 554555</SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Date: 02/11/2017</SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Method of transaction: XXX Credit</SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Amount: 155403,09</SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Account number: 678919</SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Date: 16/10/2017</SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Method of transaction: XXX Credit</SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Amount: 151698,36</SPAN></P><P></P><P></P><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Expected output on my Qlikview application is</SPAN></P><P></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0" style="padding: 0px 5.4pt;" width="0"><TBODY><TR><TD nowrap="nowrap" style="padding: 0px 5.4pt; border: #000000; border-image: none;" valign="bottom" width="116"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: black; font-size: 12pt; font-family: Calibri;">Account number</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0px 5.4pt; border: #000000; border-image: none;" valign="bottom" width="85"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: black; font-size: 12pt; font-family: Calibri;">Date</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0px 5.4pt; border: #000000; border-image: none;" valign="bottom" width="152"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: black; font-size: 12pt; font-family: Calibri;">Method of transaction</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0px 5.4pt; border: #000000; border-image: none;" valign="bottom" width="80"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: black; font-size: 12pt; font-family: Calibri;">Amount</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0px 5.4pt; border: #000000; border-image: none;" valign="bottom" width="116"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P align="right" style="text-align: right;"><SPAN style="color: black; font-size: 12pt; font-family: Calibri;">122225</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0px 5.4pt; border: #000000; border-image: none;" valign="bottom" width="85"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: black; font-size: 12pt; font-family: Calibri;">09/01/2018</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0px 5.4pt; border: #000000; border-image: none;" valign="bottom" width="152"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: black; font-size: 12pt; font-family: Calibri;"> XXX Credit</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0px 5.4pt; border: #000000; border-image: none;" valign="bottom" width="80"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: black; font-size: 12pt; font-family: Calibri;">33610,97</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0px 5.4pt; border: #000000; border-image: none;" valign="bottom" width="116"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P align="right" style="text-align: right;"><SPAN style="color: black; font-size: 12pt; font-family: Calibri;">554555</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0px 5.4pt; border: #000000; border-image: none;" valign="bottom" width="85"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: black; font-size: 12pt; font-family: Calibri;">02/11/2017</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0px 5.4pt; border: #000000; border-image: none;" valign="bottom" width="152"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: black; font-size: 12pt; font-family: Calibri;"> XXX Credit</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0px 5.4pt; border: #000000; border-image: none;" width="80"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: black; font-size: 12pt; font-family: Calibri;">155403,09</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0px 5.4pt; border: #000000; border-image: none;" valign="bottom" width="116"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P align="right" style="text-align: right;"><SPAN style="color: black; font-size: 12pt; font-family: Calibri;">678919</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0px 5.4pt; border: #000000; border-image: none;" valign="bottom" width="85"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: black; font-size: 12pt; font-family: Calibri;">16/10/2017</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0px 5.4pt; border: #000000; border-image: none;" valign="bottom" width="152"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: black; font-size: 12pt; font-family: Calibri;"> XXX Credit</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0px 5.4pt; border: #000000; border-image: none;" valign="bottom" width="80"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: black; font-size: 12pt; font-family: Calibri;">151698,36</SPAN></P></TD></TR></TBODY></TABLE><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><P></P><P>Your assistance will be highly appreciated</P><P></P><P></P><P></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Transforming-Data/m-p/52796#M791009 zwyne 2020-11-25T16:16:04Z Re: Transforming Data https://community.qlik.com/t5/QlikView/Transforming-Data/m-p/52797#M791010 <HTML><HEAD></HEAD><BODY><P>From Email you want to pull data?</P></BODY></HTML> Mon, 05 Feb 2018 15:00:14 GMT https://community.qlik.com/t5/QlikView/Transforming-Data/m-p/52797#M791010 Anil_Babu_Samineni 2018-02-05T15:00:14Z