Load data into Qlikview in the same format as the source DB

[#1]

Hi,

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?

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.

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?

Thanks!

[#2]

HI

IN QLIKVIEW TRY THESE

TEXT(VALUE)

OR

NUM(VALUE)

EXAMPLE--

LOAD *,

NUM(VALUE) AS VALUE_NEW,

TEXT(VALUE) AS VALUE_NEW1

FROM ...;

[er_mohit]

as you trying to load the data same as database then use text function

like

text(Value) as Value1 //do this in script

hope it helps

[#4]

thanks for the reply. but i cannot have two value columns. i need all the values in one column (which is the VALUE column).

[#5 · Accepted solution]

write this in script

TEXT(VALUE) AS VALUE

[Gysbert_Wassenaar]

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.

SET ThousandSep=',';

SET DecimalSep='.';

[#7]

thanks. this works! 🙂

[#8]

yes. i checked and made sure that these settings are correct. 🙂