topic Re: Loading in QlikView

Loading

Wed, 31 Dec 2014 08:48:40 GMT

Hi all,

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

thanks

Re: Loading

Wed, 31 Dec 2014 08:58:43 GMT

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

WHERE Category <> 'Total Revenue';

Re: Loading

Wed, 31 Dec 2014 09:00:13 GMT

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

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

Re: Loading

alkesh_sharma — Wed, 31 Dec 2014 09:04:08 GMT

LOAD *

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

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

Re: Loading

Anonymous — Wed, 31 Dec 2014 09:05:46 GMT

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

));

Re: Loading

Wed, 31 Dec 2014 09:21:24 GMT

This code is not working can you help me on this

Re: Loading

alkesh_sharma — Wed, 31 Dec 2014 09:29:40 GMT

What is the error?

Re: Loading

Wed, 31 Dec 2014 09:31:54 GMT

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

Re: Loading

Wed, 31 Dec 2014 09:33:49 GMT

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';

Re: Loading

Wed, 31 Dec 2014 10:00:22 GMT

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

Re: Loading

Anonymous — Wed, 31 Dec 2014 10:02:10 GMT

Re: Loading

Wed, 31 Dec 2014 10:13:36 GMT

Problem solved now.. thanks..