4 Replies Latest reply: Aug 11, 2016 11:10 AM by Sunny Talwar RSS

    Load scritpts function NoOfRow with variable as tablename

    Manfredo Ilardi

      I'm trying to show the number of rows in a load script.  It works when I wirte directly the name of the table in the function noOfRows, but is does not if I use a variable (for every other purpose the variable works).

       

      Here a sample

       

      SET TABLE_NAME_03 = Monthly_Sales;

       

      $(TABLE_NAME_03):
      LOAD
      *
       

       

      FROM
      $(TABLE_NAME_03)_2016.qvd
      (
      qvd)

       

       

       

      let Rows_in_structure = NoOfRows($(TABLE_NAME_03)); => This line returns always NULL
      let Rows_in_structure = NoOfRows('Monthly_Sales'); => This line returns the correct number of rows.

       

      Does anybody knows how to use variable with the function NoOfRows?

       

      Thank for your help