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?





          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))))