Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey guys,
Nowadays I use excel files for a qlikview document, but it has taken quite long time to extract them from my program. We have as an alternative use .csv files, but when I load it, the fields comes as text, and the separator is "."... I want to change this separator to "," (comma as decimal separator), and them make qlikview read this text as numbers.
I tryed to use num#() formula, but it's not working, i think it's due this separator.
So, how do I change that?
Thank you,
hi, you can try this in script.
Num(Replace(Filed,'.',',')) as Number
Best Regards.
Tonial
Hi Julio,
why num#() is not working? Have you tried with all parameters:
num#(field, '#0.00', '.', ',') as MyNumber
- Ralf
Hey Ralf, i'll try with those, i haven't tried with all parameters...
Ops... virtual memory exceeded... My database das 180,000 lines x 25 columns that needs to be transformed... Is it too much perhaps?
Did you try to manipulate this?
SET MoneyDecimalSep=','; SET MoneyDecimalSep='.';
Alternatively, Add a layer of transformation from xls to QVD before using your data.
I tried that, some values started to appear, but it's like 10% of everything... I don't have a clue why, but it was worth the shot.
OK. Could y ou maybe post examples of some records (or an small extract in XLS and CSV)?
These are 'peanuts' to QlikView.
Could you post a sample of your csv?
I can't upload samples, those are classified =[