4 Replies Latest reply: Aug 10, 2012 10:31 AM by pablolerner RSS

    Counting records in load Script

      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