Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
May 10, 2022 3:25:39 PM
Nov 27, 2013 8:40:32 AM
Data with alphanumerical values are loaded into QlikView and Qlik Sense.
Qlik Sense Enterprise on Windows
QlikView
Qlik Cloud
Qlik Sense Business
The script variable ExponentNumberNotation is set to 0, to disable interpretation of E and D as exponential values.
The same variable is applicable for Qlik Sense too.
SET ThousandSep=' ';
SET DecimalSep=',';
SET ExponentNumberNotation = 0;
LOAD * INLINE [
AlphaNumerical
1E1
2D2
3e3
4d4
];
The script above is expected to load the values as text, meaning that the numerical interpretation is Null.
Instead, the loaded data still has numerical values for the notation E values.
The reason for the observed issue is a product design limitation, which limits the usage of the script variable ExponentNumberNotation.
If ExponentNumberNotation=0 the decimal separator and thousands separators must be either dot or comma, in order to disable both D and E notation for exponential values.
There are two different ways to resolve the issue.
SET ThousandSep=',';
SET DecimalSep='.';
ORSET ThousandSep='.';
SET DecimalSep=',';
LOAD
Text(AlphaNumercial) AS AlphaNumerical
Inline [
AlphaNumercial
1E1
2D2
3e3
4d4
];