Skip to Content
0
Former Member
Jul 26, 2005 at 12:53 PM

Change of double index row with routine

14 Views

Hi all,

my problem is the following:

a datasource (transaction data, flat-file) contains non-unique records (in terms of the ODS).

my idea is to update an aditional attribute (as another key-field in the ods) of all multiple records.

the attribute should be filled with a continuous value, depending on the number of multiple entries.

e.g.:

<b>id1 id2 id3 attribute (automatic value as key via routine)</b>

...

10 10 10 1010

10 20 10 1010

10 20 20 1010

<b>10 10 30 1010

10 10 30 1020 1st multiple entry

10 10 30 1030 2nd multiple entry

</b>...

the routine should be identifying the multiple records and automatically set the value for the new key-attribute.

any idea?

regards

stefan