2 Replies Latest reply: Aug 4, 2016 8:52 AM by Jonathan Penuliar RSS

    $ Sign Convention in Loading Script

    Pranjal Gupta

      Please Help me with my Script, I am trying to import Sheets from Xcel File , based on the it's Name stored in the Sheet, It is showing error When it's picking up the Sheet name in the Code (Marked as Bold).

       

      NurturingOps:

      LOAD [Ops Name]

      FROM [lib://Nurturing (win-gt1ds6k1q8k_administrator)]

      (ooxml, embedded labels, table is [Ops Name])

      Where len([Ops Name])>0

      ;

       

       

      countops:

      Load count(distinct [Ops Name]) as "Ops Count"

      resident NurturingOps;

       

       

      Let vcountops=peek([Ops Count]);

      drop table countops;

       

       

      for i=1 to 1

      //Let vOpsname=peek([Ops Name],$(i),NurturingOps);

      LET vsheetName = purgeChar(purgeChar(peek([Ops Name],$(i),NurturingOps), chr(39)), chr(36));

      '$(vsheetName)':

      CrossTable([Opps Remark Date],[Nurturing Remark])

      LOAD [Trip ID],

        [42584.0]

      FROM [lib://Nurturing (win-gt1ds6k1q8k_administrator)]

      (ooxml, embedded labels, table is [$(vsheetName)] );

      next i;