7 Replies Latest reply: Jul 22, 2015 3:23 PM by Mark Graham RSS

    Count Function in Script

    Mark Graham

      Hi,

       

      I have a table where fields were as follows:

      temp1:

      Load D1, D2, D3, D4, D5...D10 from table;

       

       

      I wanna perform count(D2) in script.

      So, the script should be like...

       

      temp2:

      Load D1, D2, Count(D2), D3, D4, D5 from table Group by D1, D2 D3, D4, D5..D10;

       

       

      Instead, Can i follow the approach...

       

      temp1:

      Load D1, D2, D3, D4, D5..D10 from table;

      join

      Load D2, Count(D2) from table Group by D2;