topic Re: Load data into Qlikview in the same format as the source DB in QlikView https://community.qlik.com/t5/QlikView/Load-data-into-Qlikview-in-the-same-format-as-the-source-DB/m-p/399806#M484339 <HTML><HEAD></HEAD><BODY><P>as you trying to load the data same as database then use text function</P><P>like</P><P>text(Value) as Value1 //do this in script </P><P>hope it helps</P></BODY></HTML> Thu, 23 May 2013 09:49:30 GMT er_mohit 2013-05-23T09:49:30Z Load data into Qlikview in the same format as the source DB https://community.qlik.com/t5/QlikView/Load-data-into-Qlikview-in-the-same-format-as-the-source-DB/m-p/399804#M484337 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Is there a way to force qlikview to load the data in the same exact format as the data was from the original database source?</P><P></P><P>We are loading data from oracle database to QVD files. But I found that when I try to load the data from QVD file, the format has been changed.</P><P></P><P>From the image below, those highlighted in green has been changed. I cannot use the NUM format because not all values are numeric. So I need qlikview to load the data as it was from the DB source. Any idea how to solve this?</P><P><IMG __jive_id="41574" class="jive-image" alt="data format.jpg" src="/legacyfs/online/41574_data format.jpg" /></P><P></P><P>Thanks!</P></BODY></HTML> Thu, 23 May 2013 09:31:25 GMT https://community.qlik.com/t5/QlikView/Load-data-into-Qlikview-in-the-same-format-as-the-source-DB/m-p/399804#M484337 2013-05-23T09:31:25Z Re: Load data into Qlikview in the same format as the source DB https://community.qlik.com/t5/QlikView/Load-data-into-Qlikview-in-the-same-format-as-the-source-DB/m-p/399805#M484338 <HTML><HEAD></HEAD><BODY><P>HI</P><P>IN QLIKVIEW TRY THESE</P><P><STRONG>TEXT(VALUE)</STRONG></P><P><STRONG>OR<BR /></STRONG></P><P><STRONG>NUM(VALUE)</STRONG></P><P><STRONG><BR /></STRONG></P><P>EXAMPLE--</P><P>LOAD *,</P><P>NUM(VALUE) AS VALUE_NEW,</P><P>TEXT(VALUE) AS VALUE_NEW1</P><P></P><P>FROM ...;</P></BODY></HTML> Thu, 23 May 2013 09:38:17 GMT https://community.qlik.com/t5/QlikView/Load-data-into-Qlikview-in-the-same-format-as-the-source-DB/m-p/399805#M484338 2013-05-23T09:38:17Z Re: Load data into Qlikview in the same format as the source DB https://community.qlik.com/t5/QlikView/Load-data-into-Qlikview-in-the-same-format-as-the-source-DB/m-p/399806#M484339 <HTML><HEAD></HEAD><BODY><P>as you trying to load the data same as database then use text function</P><P>like</P><P>text(Value) as Value1 //do this in script </P><P>hope it helps</P></BODY></HTML> Thu, 23 May 2013 09:49:30 GMT https://community.qlik.com/t5/QlikView/Load-data-into-Qlikview-in-the-same-format-as-the-source-DB/m-p/399806#M484339 er_mohit 2013-05-23T09:49:30Z Re: Load data into Qlikview in the same format as the source DB https://community.qlik.com/t5/QlikView/Load-data-into-Qlikview-in-the-same-format-as-the-source-DB/m-p/399807#M484340 <HTML><HEAD></HEAD><BODY><P>thanks for the reply. but i cannot have two value columns. i need all the values in one column (which is the VALUE column).</P></BODY></HTML> Thu, 23 May 2013 09:55:34 GMT https://community.qlik.com/t5/QlikView/Load-data-into-Qlikview-in-the-same-format-as-the-source-DB/m-p/399807#M484340 2013-05-23T09:55:34Z Re: Load data into Qlikview in the same format as the source DB https://community.qlik.com/t5/QlikView/Load-data-into-Qlikview-in-the-same-format-as-the-source-DB/m-p/399808#M484341 <HTML><HEAD></HEAD><BODY><P>write this in script</P><P><STRONG>TEXT(VALUE) AS VALUE</STRONG></P></BODY></HTML> Thu, 23 May 2013 09:58:23 GMT https://community.qlik.com/t5/QlikView/Load-data-into-Qlikview-in-the-same-format-as-the-source-DB/m-p/399808#M484341 2013-05-23T09:58:23Z Re: Load data into Qlikview in the same format as the source DB https://community.qlik.com/t5/QlikView/Load-data-into-Qlikview-in-the-same-format-as-the-source-DB/m-p/399809#M484342 <HTML><HEAD></HEAD><BODY><P>Check that your decimal and thousands separators are set correctly. I think they're not correct now and that's why some numbers aren't interpreted as numbers.</P><P></P><P>SET ThousandSep=',';</P><P>SET DecimalSep='.';</P></BODY></HTML> Thu, 23 May 2013 10:03:49 GMT https://community.qlik.com/t5/QlikView/Load-data-into-Qlikview-in-the-same-format-as-the-source-DB/m-p/399809#M484342 Gysbert_Wassenaar 2013-05-23T10:03:49Z Re: Load data into Qlikview in the same format as the source DB https://community.qlik.com/t5/QlikView/Load-data-into-Qlikview-in-the-same-format-as-the-source-DB/m-p/399810#M484343 <HTML><HEAD></HEAD><BODY><P>thanks. this works! <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P></BODY></HTML> Thu, 23 May 2013 11:49:31 GMT https://community.qlik.com/t5/QlikView/Load-data-into-Qlikview-in-the-same-format-as-the-source-DB/m-p/399810#M484343 2013-05-23T11:49:31Z Re: Load data into Qlikview in the same format as the source DB https://community.qlik.com/t5/QlikView/Load-data-into-Qlikview-in-the-same-format-as-the-source-DB/m-p/399811#M484344 <HTML><HEAD></HEAD><BODY><P>yes. i checked and made sure that these settings are correct. <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P></BODY></HTML> Thu, 23 May 2013 11:50:23 GMT https://community.qlik.com/t5/QlikView/Load-data-into-Qlikview-in-the-same-format-as-the-source-DB/m-p/399811#M484344 2013-05-23T11:50:23Z