Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all!
I´ve got troubles importing the file attached "input.txt". Once imported all amount values are recognized in Qlickview as text format and I can´t sum up. The expected result for amount in july should be 76,49 eur.
How can I convert the textformat into value format in order to allow additions? I am attaching both files input.txt (original) and input.qvw (import result).
thanks!
David
You seem to be using ',' as your decimal seperator:
SET DecimalSep=',';
Because your numbers have periods '.' as the decimal seperator, they're probably not getting read correctly.
You seem to be using ',' as your decimal seperator:
SET DecimalSep=',';
Because your numbers have periods '.' as the decimal seperator, they're probably not getting read correctly.
it works! thanks a lot.