topic Re: Counting records in load Script in QlikView

Counting records in load Script

Wed, 01 Aug 2012 21:08:57 GMT

Hello. I'm trying to count table records but don't know how to. I need to know how many records have a valid value (not null and not empty) in Field_1 from Table_1, and they match relation with Table_2, when Field_1 of Table_2 is also a valid value.

I need to know how many records match the relation between Table_1 and Table_2, when there are valid values in field Table_1_Field_1 and field Table_2_Field_1. I have tried with a join of the two tables so I can use the Count function, but memory in my computer is not enough and the application hangs. Anyone knows any other way?

Relation between tables comes from field Key_1 in both tables.

I appreciate any help,

Pablo Lerner

Re: Counting records in load Script

MayilVahanan — Wed, 01 Aug 2012 21:15:36 GMT

Try like this,

While joining the tables, use rowno() by this, you can able to see how many records in that table..

Re: Counting records in load Script

Thu, 02 Aug 2012 06:22:11 GMT

Hope it helps!

tab1:
Load * from abc.csv;
Let a = NoOfRows('tab1');

Re: Counting records in load Script

Fri, 10 Aug 2012 11:37:48 GMT

Mark it as answer if helped you...

Re: Counting records in load Script

Fri, 10 Aug 2012 14:31:16 GMT

Well, I appreciate all answers, but a join is not usefull for me since the application hangs due to not enough memory. I have decided to create a small datawarehouse in a RDBMS, do all data management and calculations there, and import data as is into Qlikview. That, I think, will be much easier for me.