8 Replies Latest reply: Sep 20, 2017 4:50 PM by Stefan Wühl RSS

    Using FieldName in a Where Clause

    Eduardo DImperio

      Hi,

       

      I've this situation

       

      Input:

       

      LOAD

      //more fields before

      '42990'

      '42991'

      '42992'

      '42993'

      '42994'

      '42995'

      '42996'

      '42997'

      '42998'

      '42999'

      //more fields after

      FROM [lib://VisitaMI (bi_bi.desenvolvimento)/CONTROLE - AGENDAMENTO -2016-2017-2018 V012.xlsx]

      (ooxml, embedded labels, table is Geral);

       

      This came from a Excel file where each field is a date.

       

      How can i select only the field where field's name ate equal today? (42998)

       

       

      I thought something like :

       

      LOAD

      *

      FROM [lib://VisitaMI (bi_bi.desenvolvimento)/CONTROLE - AGENDAMENTO -2016-2017-2018 V012.xlsx]

      (ooxml, embedded labels, table is Geral)

      WHERE FieldName() = Num(Today());

       

       

      Any Help Please