Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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))))
)
;
Can you post a sample spreadsheet?
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 ?
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
just data
remove "embedded labels" from your load statement.
Rob