3 Replies Latest reply: Jan 27, 2014 11:11 PM by Michael Solomovich RSS

    Section Application Multiple fields created circular ref

    Sudeep Mahapatra

      Hi I'm working on a Section Access implementation. Given below are three tables from which I source data.

      SAISSUE.png

      The section access has to be implemented for row level reduction of COUNTRY and ORG fields.

      When I write the section access script like below I'm getting a circular reference in my data model.

      SECTION Access;

      USER:

      LOAD ACCESS,    USERNAME,    PASSWORD,    OMIT,   ORG,   COUNTRY

      FROM SASAMPLETEST.xlsx

      (ooxml, embedded labels, table is Sheet1);

      SECTION Application;

      LOGIC:

      LOAD     ORG,  COUNTRY
      FROM GFISASAMPLETEST.xlsx

      (ooxml, embedded labels, table is Sheet2);

      Can anyone pls provide any suggestions?

      Regards,

      Sudeep