Counting records in load Script

[#1]

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

[MayilVahanan]

HI

     Try like this,

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

[#3]

Hope it helps!

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

[#4]

Mark it as answer if helped you...

[#5 · Accepted solution]

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.