Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
menphis12
New Contributor

How to get the number of lines of a dataset before import (log information)

hello Guys,

Before starting my job to make analysis on date, i have to compare the number of lines of each tables and after import theses tables on Qliksense.

Sometimes, we get some erros because of a specifi character or a space, or something else...

When we import a data, there is a log who report the number of lines on the data table and the number of lines imported.

Can i get it ?

I want to make a script who gives me a table with :

Table name, number of lines on the source file, number of lines after import

Many thanks

Tags (3)
1 Reply
MVP & Luminary
MVP & Luminary

Re: How to get the number of lines of a dataset before import (log information)

The function NoOfRows('table') will give you the number of rows in a table. So something like:

MyTable:

LOAD ,,, FROM ,,,;

Stats:

LOAD NoOfRows('MyTable') as ImportedRows

AutoGenerate 1;

Also, the system fields $Table and $Rows can be used in a chart or tablebox to display the number of rows in each table in the data model.

-Rob