2 Replies Latest reply: May 25, 2014 1:44 AM by Jerry Lau RSS

    section access - data reduction - captial letter required?

    Jerry Lau

      if i want to use section access to reduce data for a field

      that field name must be in upper case (and not even a space between?)

      so how about if the field in my data model does not fulfill the condition (e.g. CompanyCode)?

      is there no way to perform section access but only changing the field name to capital letters (COMPANYCODE)?

       

      Thanks

       

      ==================================================

       

      e.g. (from this community)

       

      Section Access;

      LOAD * INLINE [

      ACCESS,  USERID,  PASSWORD,  REGION

      ADMIN,  ADMIN,  ADMIN,

      USER,  USER1,  U1,   AFRICA

      USER,  USER2,  U2,   AMERICA

      USER,  USER3,  U3,   ASIA

      USER,  USER4,  U4,   EUROPE

      USER,  USER5,  U4,   AMERICA

      USER,  USER5,  U5,   *

      ];

      Section Application;

      SALES:

      LOAD * INLINE [

      REGION,  PROFIT

      AFRICA,  1000

      AMERICA,  2000

      ASIA,  3000

      EUROPE,  4000

      OCEANIA,  5000

      ];

        • Re: section access - data reduction - captial letter required?
          Fernando Keuroglian

          Hi, you dont have to change your dimension name, you can use UPPER() functions to do this

           

          see this example

           

          SECTION ACCESS;

           

          Directory;

          LOAD ACCESS,

               NTNAME,

               GROUP,

              UPPER([DIVISION Id]) as [DIVISION ID]

          FROM

          USER.xlsx

          (ooxml, embedded labels, table is Sheet1);

           

          SECTION APPLICATION;

           

          Directory;

          LOAD

               GROUP,

               SHEET1,

               SHEET2

          FROM

          SHEET.xlsx

          (ooxml, embedded labels, table is Sheet1);

           

           

          [Division Table]:

          LOAD * INLINE [

          DIVISION ID, description, Employee

          01, bird, fernandoperez

          01, bird2, fernandoperez

          02, food, marcosaguirre

          ];

           

           

          hope this helps

           

          Fernando