Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
Good Morning.
I am new to QlikView. I want to connect to a MS SQL Server Database and get the total rows count of a particular table through scripting in QlikView.
In SQl I would do it Like this : Select count(*) From Table1 . This returns the total no.of rows in Table1.
Thanks in advance for the help..
Regards,
Krunal. Shaholia
Did you install your ODBC driver using system DSN for your sql server db? Once you establish ODBC you can just run the script in your Qlikview like below:
TotalRowCnt:
LOAD *;
SQL Select Count(*) AS TotalRows
From Table1;
Did you install your ODBC driver using system DSN for your sql server db? Once you establish ODBC you can just run the script in your Qlikview like below:
TotalRowCnt:
LOAD *;
SQL Select Count(*) AS TotalRows
From Table1;
Dear Vishwarath,
Good Morning.
Thanks for all your help. I script code that you have sent is working fine and that is what I was looking for.
Thanks & Regards,
Krunal.Shaholia.
Hi Vishwarath,
Good Morning.
The script code that you have provided is working. Thanks for your help.
Regards,
Krunal. Shaholia
Your solution works perfect!
I have further question that-
Will this count function in SQL take same time to execute as it will take to load entire table with just one field to get the row count!!?