topic Re: loading text file in qlikview in QlikView

loading text file in qlikview

Anonymous — Wed, 13 May 2015 17:58:06 GMT

Hi experts-

I am using version 10 SR 6 and trying to upload a text file. I am not able to find txt format in wizard. Please find the screenshot attached. csv format is also not there. Any idea why I am not able to find txt or csv in table type.

Thanks!

Re: loading text file in qlikview

Clever_Anjos — Wed, 13 May 2015 18:02:59 GMT

Maybe you can use "delimited" or "fixed record"

Re: loading text file in qlikview

maxgro — Wed, 13 May 2015 18:17:18 GMT

try delimited, with comma (after semicolon) delimiter

Re: loading text file in qlikview

petter — Wed, 13 May 2015 18:39:38 GMT

What kind of text-file did you have in mind. Both CSV and fixed record are special forms of text-files. Even XML is a text-file. Some formats are well-defined and strict - some are not. Is it free-text like a document or something created in Notepad you are thinking of? If it is table oriented both CSV (comma separated values - where comma could be replaced with pretty much anything else than comma) and fixed-record covers most cases.

CSV-files often have delimiters (character) between the columns that is comma , semicolor ; or tab (ASCII / ANSI / ISO / Unicode code number 9 ).

Excel is particularly well-behaved when using CSV-files that have tabs between the columns. They are sometimes also referred to as TSV / Tab delimited.

Even though a file-extension can indicate what the text-file contains it might not be accurate and there are no fixed conventions that everyone sticks to.

Re: loading text file in qlikview

Anonymous — Wed, 13 May 2015 20:08:37 GMT

Thanks for replying to this post. I used delimited but I remember that in table type I have seen txt and csv listed, in the same way Xml, Qvd or other formats are listed. I might be wrong.