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!!!