Notation E interpreted as numerical with script variable ExponentNumberNotation=0

Data with alphanumerical values are loaded into QlikView and Qlik Sense.

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.



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 script variable ExponentNumberNotation.

If ExponentNumberNotation=0 the decimal separator and thousand separator must be either dot or comma, in order to disable both D and E notation for exponential values. 



NOTE:
There is no current plan to correct this behavior, since the root cause is located in the data association engine and a change is considered very high risk.

There are two different ways to resolve the issue.

1. Change decimal and thousand separators so that they comply with the limitation
   
   OR
   
2. Format the loaded value as text during load