Settings in the block [ERPTABLE-UPDATE-COLUMNS]

In this block those columns are declared, where an update shall be performed.

Example 1:

[ERPTABLE-UPDATE-COLUMNS]
ERP_PDM_NUMBER=row.cells.item(0).value
MAT_NAME=row.cells.item(1).value
DESCRIPTION=row.cells.item(2).value

Example 2:

If a value shall be replaced in a certain column, then use the following expression:

[ERPTABLE-UPDATE-COLUMNS]
MAT_NAME=replace(row.cells.item(0).value,”Stahl”,”8.8”)