loading text file in qlikview (2024)

Skip to main content

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:

loading text file in qlikview (2)

‎2015-05-1301:58 PM

  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • 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,286 Views

0Likes

  • All forum topics
  • Previous Topic
  • Next Topic

1 Solution


Accepted Solutions

loading text file in qlikview (3)

loading text file in qlikview (4)petter

Partner - Champion III

‎2015-05-1302:39 PM

  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • 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!

679 Views

2Likes

4 Replies

loading text file in qlikview (5)

loading text file in qlikview (6)Clever_Anjos

Employee

‎2015-05-1302:02 PM

  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Report Inappropriate Content

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

678 Views

3Likes

loading text file in qlikview (7)

loading text file in qlikview (8)maxgro

MVP

‎2015-05-1302:17 PM

  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Report Inappropriate Content

try delimited, with comma (after semicolon) delimiter

679 Views

1Like

loading text file in qlikview (9)

loading text file in qlikview (10)petter

Partner - Champion III

‎2015-05-1302:39 PM

  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • 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!

680 Views

2Likes

loading text file in qlikview (11)

Anonymous

Not applicable

‎2015-05-1304:08 PM

Author

  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • 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.loading text file in qlikview (12)

679 Views

1Like

loading text file in qlikview (13)

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
loading text file in qlikview (2024)
Top Articles
Latest Posts
Article information

Author: Prof. Nancy Dach

Last Updated:

Views: 5771

Rating: 4.7 / 5 (57 voted)

Reviews: 80% of readers found this page helpful

Author information

Name: Prof. Nancy Dach

Birthday: 1993-08-23

Address: 569 Waelchi Ports, South Blainebury, LA 11589

Phone: +9958996486049

Job: Sales Manager

Hobby: Web surfing, Scuba diving, Mountaineering, Writing, Sailing, Dance, Blacksmithing

Introduction: My name is Prof. Nancy Dach, I am a lively, joyous, courageous, lovely, tender, charming, open person who loves writing and wants to share my knowledge and understanding with you.