This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
I have a lot os csv files to upload to qlikview but some of then are delimited by comma and other are delimited by semicolon.
They are at the same directory.
How can I deal with this problem to load all of then once?
Thanks in advance.
Maybe you can load the first row of each file and determine the separator from that before loading the complete file. Something like
for each vFile in filelist('c:\Test\*.csv')
LOAD [@1:n] as Header
(fix, codepage is 1252);
LOAD * FROM
(txt, codepage is 1252, embedded labels, delimiter is '$(Sep)', msq);
Drop Table Header;
View solution in original post
For csv use separator ,
and for semicolon use separator ;
Uder tab Delimiter options for coma,semicolon.tab,space,are available
use which one do you want and then load the files.
The problem is that in the same directory I have some csv with ';' delimiter and other csv with ',' delimiter.
My doubt is if I can choose both of then to load once in qv.
It worked perfectly.