topic WHat does remove() in following function does ?? in QlikView

WHat does remove() in following function does ??

nikhilgarg — Fri, 19 Sep 2014 07:00:29 GMT

Table4:

LOAD X,

FROM

(ooxml, embedded labels, table is [Task Sheet], filters(

Remove(Row, Pos(Top, 1)),

Remove(Col, Pos(Top, 4)),

Remove(Col, Pos(Top, 3))

));

Join

LOAD Y,

FROM

(ooxml, embedded labels, table is [Task Sheet], filters(

Remove(Row, Pos(Top, 1)),

Remove(Col, Pos(Top, 1)),

Remove(Col, Pos(Top, 1))

));

WHat is the use of Remove() here ??

thanks.

PrashantSangle — Fri, 19 Sep 2014 07:04:06 GMT

Hi,

This is autogenerate Script.

When You load file in Edit script (through table Files)->then some time you dont required all column and Row

Then You can remove it at loading time.

Regards

rubenmarin — Fri, 19 Sep 2014 07:05:15 GMT

Hi nikhil, it avoids to load rows or columns from excel in QV.

The first LOAD avoids the first row and the 3rd and 4th columns of Join Task xlsx.

The second LOAD avoids the first row and the two firsts columns of Join Task.xlsx

phaneendra_kunc — Fri, 19 Sep 2014 07:12:10 GMT

As every one said this is Auto generated script.

When you load an Excel file through Table File wizard in edit script you can use "Transformation step" to manipulate some of the columns/rows.