5 Replies Latest reply: Dec 7, 2015 5:26 PM by Rob Wunderlich RSS

    unable to remove row after renaming column

       

      I need to remove rows where the date (first column in an excel spreadsheet) is empty,  unfortunately the following script returns "field not found - <F1>"

        Any idea?

       

       

      LOAD

       

          F1 as "Date",

       

          "Number of Project",

       

      10 as "Number of projects benchmark"

       

      FROM [lib://KPIs Data/Risks & Perf-OK\Perf KPI_PF.xls]

       

      (biff, embedded labels, header is 1 lines, table is DB$, filters(Remove(Row, RowCnd(CellValue, 1, StrCnd(null))))

       

      )

       

      ;