Linking Fields

[#1]

Hello,

I have data from two tables with the same name, Program ID. However, the data in one table has the prefix. "PRG-" before the program number and the other filed only has the number.

To illustrate:

Table 1 -

Program ID:

1010102

1010103

1010104

Table 2 -

Program ID:

PRG-1010102

PRG-1010103

PRG-1010104

How can I make these two join in the load statement?

[MarcoWedel]

Hi,

2 only takes the second '-'delimited subfield, while leaving out this third parameter in the script loads one row for all the subfields, i.e. it creates additional rows.

So in this case you should be cautious, as additional rows might change some aggregation results in your application (e.g. sums or counts).

The three parameter SubField() version seems the better choice here as it doen't change the row count while the matching information is restricted to only the second subfield anyhow.

hope this helps

regards

Marco