Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Requirement on Removing Row from Excel Sheet

hi

How to Remove Row from Excel Sheet while loading into the Script .

1 Solution

Accepted Solutions
santiago_respane
Specialist
Specialist

Hi,

it would be easier to help if you could share a sample app, but maybe this helps you.

To omit some rows based on data you use Clever tip but to omit specific rows based on the excel file format you can do this:

MyLoadedExcel:

LOAD *

FROM

[My Excel.xlsx]

(ooxml, embedded labels, table is [MyDataSheet],

filters(

Remove(Row, Pos(Top, 1)),    //this rule removes the first row

Remove(Row, RowCnd(CellValue, 1, StrCnd(start, 'Total')))  //This rule removes all rows that starts with total

Remove(Row, RowCnd(CellValue, 1, StrCnd(equal, 'Report Title')))  //This rule removes a row which value is 'Report Title'

)

);


You could take a look at excel loading filters in the wizard.

Please let me know if this helps.


Kind regards,

View solution in original post

3 Replies
alexdataiq
Partner - Creator III
Partner - Creator III

Could you provide an example? Are you trying to remove headers or rows given a certain condition?

Clever_Anjos
Employee
Employee

LOAD *

FROM yourexcelfile

WHERE <clause>;

<clause> can be a rule, for example isnum(A);

santiago_respane
Specialist
Specialist

Hi,

it would be easier to help if you could share a sample app, but maybe this helps you.

To omit some rows based on data you use Clever tip but to omit specific rows based on the excel file format you can do this:

MyLoadedExcel:

LOAD *

FROM

[My Excel.xlsx]

(ooxml, embedded labels, table is [MyDataSheet],

filters(

Remove(Row, Pos(Top, 1)),    //this rule removes the first row

Remove(Row, RowCnd(CellValue, 1, StrCnd(start, 'Total')))  //This rule removes all rows that starts with total

Remove(Row, RowCnd(CellValue, 1, StrCnd(equal, 'Report Title')))  //This rule removes a row which value is 'Report Title'

)

);


You could take a look at excel loading filters in the wizard.

Please let me know if this helps.


Kind regards,