Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Qlik.com |Qlik Help |Resources
Ask a Question
Turn on suggestions Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Search instead for
Did you mean:
HelpSign In / Register
Turn on suggestions Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Search instead for
Did you mean:
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms.
Download Now- Qlik Community
- :
- All Forums
- :
- QlikView App Dev
- :
- loading text file in qlikview
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Turn on suggestions Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Search instead for
Did you mean:
Anonymous
Not applicable
2015-05-1301:58 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
loading text file in qlikview
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!
Preview file
109 KB
Ditto - same here!
1,288 Views
0Likes
- All forum topics
- Previous Topic
- Next Topic
1 Solution
Accepted Solutions
petter
Partner - Champion III
2015-05-1302:39 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
View solution in original post
Ditto - same here!
681 Views
2Likes
4 Replies
Clever_Anjos
Employee
2015-05-1302:02 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Maybe you can use "delimited" or "fixed record"
680 Views
3Likes
maxgro
MVP
2015-05-1302:17 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
try delimited, with comma (after semicolon) delimiter
681 Views
1Like
petter
Partner - Champion III
2015-05-1302:39 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Ditto - same here!
682 Views
2Likes
Anonymous
Not applicable
2015-05-1304:08 PM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
681 Views
1Like
Related Topics
Tab delimited text file -Not all rows gets loaded in qlikview
Tags
- new_to_qlikview
- new to qlikview
- qlikview_scripting
- qlikview_layout_visuali…
- qlikview_creating_analy…
- qlikview
- script
- chart
- expression
- date
- load
- table
- set_analysis
- expressions
- macro
- analysis
- scripting
- pivot
- set
- dimension
View All ≫
Community Browser
- All Forums
- GeoAnalytics
- Qlik Reporting Service
- Mobile
- QlikView Administration
- QlikView App Dev
- QlikView Connectivity
- QlikView Integrations
- Qlik NPrinting