Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
How to delete specific row data from excel while loading,following attachment i want to delete 'Total' row,
thanks
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')))
));
If Total Revenue is a value from the Field Category then just add a Where clause ?
WHERE Category <> 'Total Revenue';
If the field is in uppercase then CATEGORY <> 'Total Revenue'
and if you have more than one values to discard then use NOT MATCHES
LOAD *
from XYZ where Category <> '*Total*';
Assuming that your 'total' is in the same row as Category
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')))
));
This code is not working can you help me on this
What is the error?
This is working for me ,you gave me very helpful answer Chandel.
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';
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