loading text file in qlikview

[Anonymous]

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!

[Clever_Anjos]

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

[maxgro]

try delimited, with comma (after semicolon) delimiter

[petter · Accepted solution]

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.

[Anonymous]

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.