Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm working through the Qlik Sense Cookbook and I need to load the following data. Our Qlik Sense application is set up to European units, so it uses commas instead of decimals. This is what I want to write in "American" units:
Load * INLINE [
Period, BounceRate
1, 0.26
2, 0.25
3, 0.24
];
Qlik sense isn't reading these as values. I can get through the exercise by just making them whole numbers, but I'll need to know how to do this eventually.
Thanks!
Hi! You can either change the DecimalSep in the Main section of the load script or go like this:
LOAD
Period,
REPLACE(BounceRate,'.',',') AS BounceRate
INLINE [
Period, BounceRate
1,0.26
2,0.25
3,0.24
](DELIMITER IS ',');
Hi! You can either change the DecimalSep in the Main section of the load script or go like this:
LOAD
Period,
REPLACE(BounceRate,'.',',') AS BounceRate
INLINE [
Period, BounceRate
1,0.26
2,0.25
3,0.24
](DELIMITER IS ',');
My preferred approach to handle such cases is to quote such values like:
Load * INLINE [
Period, BounceRate
1, "0,26"
2, "0,25"
3, "0,24"
];
or to replace the load-delimiter - usually with a tab-char because they are often created with excel and copy & paste here - like:
Load * INLINE [
Period | BounceRate |
1 | 0,26 |
2 | 0,25 |
3 | 0,24 |
] (txt, delimiter is \t);
If both approaches aren't practically enough you could of course transform the values with a replace like mentioned from Ivan or also with a num(num#()) approach.
- Marcus