Discussion Board for collaboration on QlikView Scripting.
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
The function NoOfRows('table') will give you the number of rows in a table. So something like:
LOAD ,,, FROM ,,,;
LOAD NoOfRows('MyTable') as ImportedRows
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.