5 Replies Latest reply: Aug 14, 2017 10:47 AM by siva bose RSS

    Why null values stored in variables

    vengadesh palani

      Hi all,

      In the below screenshot, I've got null values in variables as marked in the screenshot. Please anyone could say what I did wrong in the script?

      Screenshot_3.png

       

       

      A:

      LOAD VarCustomer, IN, OUT

      FROM [C:\Users\Vengadesh.p\Desktop\test2.xls] (biff, embedded labels, table is Sheet1$);

      let noRows = NoOfRows('A');

      TRACE '$(noRows)';

      for i=1 to $(noRows)

      TRACE '----------------------------------------------'; 

      TRACE '$(i)'; 

      let vVar=  FieldValue('VarCustomer',$(i)) ;

      let vOriginFormat = FieldValue('IN',$(i));

      let vDestinationFormat = FieldValue('OUT',$(i));

      TRACE '$(vVar)';

      TRACE '$(vOriginFormat)';

      TRACE '$(vDestinationFormat)';

      next i

      EXIT SCRIPT;