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