WHat does remove() in following function does ??

[nikhilgarg]

Table4:

LOAD X,

Y

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,

Z

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]

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]

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]

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.