Skip to Content
0
Former Member
Dec 11, 2006 at 08:42 AM

Mapping - Please Help

49 Views

Hi Experts,

We would appreciate your help on one thing,

We are trying to do a mapping but I think we are going to need an advanced UDF for it and I don't know how to write one... so any of you Java Programmers out there I would much appreciate some code 😊

Basically the structure is this (Bare in mind Recordset is the parent node to records and records is the parent node to ID)

Recordset

Records

ID

Recordset

Records

ID

Recordset

Records

ID

Recordset

Records

ID

Recordset

Records

ID

Recordset

Records

ID

Now what I want to do is map the first instance of the ID Field.

So basically I need to the function to go through all the context/occurences of ID and map only the ID's which occur first! and not to map the duplicate ID's.

So for example if my source was

Recordset

Records

ID - 1

Recordset

Records

ID - 2

Recordset

Records

ID - 3

Recordset

Records

ID - 2

Recordset

Records

ID - 4

Recordset

Records

ID - 1

Then my target should have the values

1

2

3

4

and the second instance of 1 and 2 would be ignored...

Could someone please give me some code that would do this in an advanced UDF

Urgent!!!