4 Replies Latest reply: Feb 8, 2017 12:26 PM by Eduardo DImperio RSS

    Help with variables

    Eduardo DImperio

      Hi everyone

       

      im trying to use the string inside a variable as path

       

      but its not working, someone could help me?

       

      Variaveis:

      load

        LOCAL

      FROM [lib://Athena-Lib\CAS_Enderecos.xlsx]

      (ooxml, embedded labels, table is Ultragaz);

      NoConcatenate

      Find:

      LOAD

      LOCAL

      Resident Variaveis

      WHERE LOCAL like '*RS_SYSTEM.qvd*';

       

       

      Let $vLocal=FieldValue('LOCAL',1);

       

      drop table Variaveis;

       

       

      CADASTRO:

      LOAD

         OID_SYSTEM,

          OID_GROUP,

          NAME_SYSTEM,

          ADDRESS_SYSTEM,

          ADDRESS_NUMBER_SYSTEM,

          SSN_REMOTE_SYSTEM,

          mid(SSN_REMOTE_SYSTEM,5,2) as CODIGO_OPERADORA,

          MIN_REMOTE_SYSTEM,

          NEIGHB_SYSTEM,

          CITY_SYSTEM,

          UF_SYSTEM,

          CEP_SYSTEM,

          STATUS,

          ID_SYSTEM_TYPE

      FROM $(vLocal) (qvd);      // value of variable [lib://Ultragaz QVD/RS_SYSTEM.qvd]