Skip to Content
0
Former Member
Dec 10, 2006 at 05:04 PM

Mapping

30 Views

Hi Guys...

I wanted some help...

I am trying to do a maopping but I think I am 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 my structure is this

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 every unique 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 a UDF