Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Loading

Hi all,

How to delete specific row data from excel while loading,following attachment i want to delete 'Total' row,

thanks

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Use conditional delete in transformation

LOAD Factors,

     F2,

     F3,

     Estimated,

     F5,

     Actuals,

     F7,

     [Cumulative Till Date]

FROM

(ooxml, embedded labels, table is Sheet1, filters(

Remove(Row, RowCnd(CellValue, 1, StrCnd(contain, 'Total')))

));

View solution in original post

11 Replies
Not applicable
Author

If Total Revenue is a value from the Field Category then just add a Where clause ?

WHERE Category <> 'Total Revenue'; 

Not applicable
Author

If the field is in uppercase then CATEGORY <> 'Total Revenue'

and if you have more than one values to discard then use NOT MATCHES

alkesh_sharma
Creator III
Creator III

LOAD *

from XYZ where Category <> '*Total*';

Assuming that your 'total' is in the same row as Category

Anonymous
Not applicable
Author

Use conditional delete in transformation

LOAD Factors,

     F2,

     F3,

     Estimated,

     F5,

     Actuals,

     F7,

     [Cumulative Till Date]

FROM

(ooxml, embedded labels, table is Sheet1, filters(

Remove(Row, RowCnd(CellValue, 1, StrCnd(contain, 'Total')))

));

Not applicable
Author

2014-12-31_14-50-05.png

This code is not working can you help me on this

alkesh_sharma
Creator III
Creator III

What is the error?

Not applicable
Author

This is working for me ,you gave me very helpful answer Chandel.

Not applicable
Author

This one is working for me  , so yours should be something similar right?

LOAD Week,

     [PRICE 12PK], 

     [PRICE 18PK], 

     [PRICE 30PK], 

     [CASES 12PK], 

     [CASES 18PK], 

     [CASES 30PK]

FROM

[Regression_example--weekly_beer_sales.xlsx]

(ooxml, embedded labels, table is Data)

Where Week <> '1';

Not applicable
Author

Hi,Mario conditional delete is working for me . However if that '1' is extra field value which we don't require then, i got the similar data. Mr. Mario try Conditional delete, its working.

Thanks