Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi
How to Remove Row from Excel Sheet while loading into the Script .
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,
Could you provide an example? Are you trying to remove headers or rows given a certain condition?
LOAD *
FROM yourexcelfile
WHERE <clause>;
<clause> can be a rule, for example isnum(A);
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,