10 Replies Latest reply: Jan 20, 2017 8:45 AM by Eduardo DImperio RSS

    Working with variables

    Eduardo DImperio

      Hey people,

       

      I need some help, i think will be a silly question cause its very simple to workaround, but i want to learn so i have this 2 codes:

       

      LET vDataCarga_ini=date(today(), 'YYYYMM');

       

       

      LOAD

      *

      FROM

      [lib://MI_csv/CONSUMO_ELEVADO_DIARIO_$(vDataCarga_ini).qvd](qvd)

      WHERE $(vDataCarga_ini)??>(TODAY()-5);

       

      ************

      CONCAT_TABLE:

      LOAD

      *

      FROM [lib://MI_csv/RS_INDIVIDUAL_READ_*.qvd]

      (qvd) where DATE_READ>TODAY()-2;

       

      If i chance code two to

      FROM [lib://MI_csv/RS_INDIVIDUAL_READ_??.qvd]

      It works fine

       

      So, why i can't do this in code one?

       

      [lib://MI_csv/CONSUMO_ELEVADO_DIARIO_$(vDataCarga_ini)??.qvd](qvd)