Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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?

data format.jpg

Thanks!

1 Solution

Accepted Solutions
Not applicable
Author

write this in script

TEXT(VALUE) AS VALUE

View solution in original post

7 Replies
Not applicable
Author

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
Master II
Master II

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

Not applicable
Author

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

Not applicable
Author

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='.';


talk is cheap, supply exceeds demand
Not applicable
Author

thanks. this works! 🙂

Not applicable
Author

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