topic Re: count(*) from Table in QlikView

count(*) from Table

bsbernabe — Fri, 15 Nov 2024 23:44:11 GMT

Hello There,

my concern is to display the Table Name, Number of Columns & numbers of rows per table from oracle db

i try to use

Load *,

SQLCOLUMN but i only got is Table Name & Number of Column i need also numbers of rows per table, so i create a simple script individually to count the number of rows per table like union SQL but my problem here is when i run the script with union i cant define what table it is because the field displayed is count like below:

Select count(*) from Table union

Any other solution for this?

i need somebody help..

Best Regards,

Bing

Re: count(*) from Table

Chanty4u — Tue, 27 Oct 2020 08:58:29 GMT

Hi,

not sure but did you tried with join instead of union?

Select count(*) from Table Join

Re: count(*) from Table

MayilVahanan — Tue, 27 Oct 2020 09:38:20 GMT

Hi @bsbernabe

If you want to know the no. of records in the table, you can use count(Primarykey) in the front end.

Load *, 1 as RowCount;

Sql select * from yoursourcetable;

Then, in front end, you can use Sum(RowCount) to get the number of rows loaded.

Hope its helps