Loading

[#1]

Hi all,

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

thanks

[#2]

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

WHERE Category <> 'Total Revenue'; 

[#3]

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]

LOAD *

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

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

[Anonymous · Accepted solution]

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

));

[#6]

This code is not working can you help me on this

[alkesh_sharma]

What is the error?

[#8]

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

[#9]

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

[#10]

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