Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Linking Fields

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?

10 Replies
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