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

menphis12 — Wed, 17 Oct 2018 16:57:54 GMT

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

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

rwunderlich — Wed, 17 Oct 2018 17:52:31 GMT

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