QlikView Delimited Files(CSV)

A delimited file, also known as a CSV (Comma Separated Values) file which is a type of text file that stores tabular data in a plain-text format. It consists of rows of data, with each row representing a record and each field within a row separated by a delimiter character, such as a comma or tab.

QlikView can natively read and import delimited files, such as CSV files, as data sources for creating QlikView documents. This allows users to easily import and work with the data from a variety of sources, including spreadsheets and databases, within QlikView.

To import a delimited file into QlikView, users can use the QlikView Data Load Editor to specify the file location and delimiter character, and then map the fields in the file to the appropriate columns in the QlikView data model. Once the data has been imported, users can use QlikView’s visualization and analysis tools to explore and analyze the data.

Delimited files are a common and convenient way to exchange data between different systems and applications, and QlikView’s support for reading and importing delimited files makes it easy for users to work with this type of data within the QlikView platform.

Data in text files with fields separated by commas, tabs, semicolons, etc. can be used by QlikView. Here, we’ll use CSV as an illustration. A CSV file is a file in which each column of data is separated by a comma. It is a fairly popular file format for storing text-based information in rows and columns for use in aircraft.

Using the Data from files options found in the script editor’s File Menu, QlikView loads csv files. A new QlikView document can be be opened by pressing control+E, which will bring up the script editor window as displayed below. Select the Product details.csv file from the relevant directory.