5.15.3.5.4. Block [ERPTABLE-IDENTIFY-COLUMNS]

Settings in the [ERPTABLE-IDENTIFY-COLUMNS] block

Here the columns are entered which are needed for the line identification in the LinkDB. If no adequate line is found and createEmptyERPdataSetIfUnknown = 1, then a new line is created.
Default:
The default setting applies if the unique number can be found in the ERP_PDM_NUMBER column on the ENTERPRISE 3Dfindit side and the corresponding information is in the first column of the CSV file in the third-party system.
```
[ERPTABLE-IDENTIFY-COLUMNS]
ERP_PDM_NUMBER=row.cells.item(0).value
```
- Example 1:
  In this example, the unique number is in the "SAP_MAT_NR" column on the ENTERPRISE 3Dfindit side. In the third-party system, the corresponding information is in the second column of the CSV file.
```
SAP_MAT_NR=row.cells.item(1).value
```
- Example 2:
  Several CSV columns are required in order to identify the correct line in the LinkDB.
  At the value in the first CSV column the leading zeros shall be removed, then an underscore be added and finally the value from column 2 be attached.
```
ERP_PDM_NUMBER=""&row.cells.item(0).value & "_" & row.cells.item(1).value
```
  Excerpt from the CSV file from column 1 and 2:
```
0000014245      001
```
  Result: The LinkDB search for the adequate line is performed with:
```
14245_001
```
- Example 3:
  For the identification of the correct LinkDB line several CSV columns, respectively LinkDB columns are needed.
```
ERP_PDM_NUMBER=row.cells.item(0).value
ERP_VERSION=row.cells.item(1).value
```
- Example 4:
  If a value shall be set in a certain column use the following expression:
```
[ERPTABLE-UPDATE-COLUMNS]
MAT_NAME=replace(row.cells.item(0).value,”Stahl”,”8.8”)
```

Prev	Up	Next
5.15.3.5.3. Block [LOAD]	Home	5.15.3.5.5. Block [ERPTABLE-UPDATE-COLUMNS]