unable to remove row after renaming column

[#1]

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

)

;

[sinanozdemir]

Can you post a sample spreadsheet?

[#3]

Thanks Sinan for jumping in  

	Number of Project
janv-14	4
févr-14	5
mars-14	5

the issue in the data comes from an empty line at the top I think, but the issue I have is with the script, how comes Remove(Row, RowCnd(CellValue, 2 StrCnd(null))) works but not Remove(Row, RowCnd(CellValue, 1, StrCnd(null)). Does it have anything to do with the column renaming? Is there a way to point to the first column without using its "1" index ?

[rwunderlich]

The "embedded labels" specification means that the first row (after filter applied) has a fieldname in it. "F1" is usually used when there is no label. Does the first non-blank row contain the label "Date" or is it just data?

-Rob

[#5]

just data

[rwunderlich · Accepted solution]

‌remove "embedded labels" from your load statement.

Rob