Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

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

 

)

 

;

 

1 Solution

Accepted Solutions

Re: unable to remove row after renaming column

‌remove "embedded labels" from your load statement.

Rob

5 Replies
sinanozdemir
Valued Contributor III

Re: unable to remove row after renaming column

Can you post a sample spreadsheet?

Not applicable

Re: unable to remove row after renaming column

Thanks Sinan for jumping in  

Number of Project
janv-144
févr-145
mars-145

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 ?

Re: unable to remove row after renaming column

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

Not applicable

Re: unable to remove row after renaming column

just data

Re: unable to remove row after renaming column

‌remove "embedded labels" from your load statement.

Rob

Community Browser