Forum Discussion
eduardovaldes
10 months agoQrew Member
what I do to identify a list of unique values is to create a kind of shadowTable.
In your case shadowSection, with only one key field (for example sectionName).
You create two formula relations between projects and boreholes, with this shadowTable.
The key field should the sectionName. That way you know how many boreholes and projects you have in that section.
When you receive the section name metadata you loop and do a prepare, add row, and commit bulk upsert in the same row.
That way the shadowTable is updated and you have a table of unique sectionsNames
After you can delete that shadowTable.
Not a great expert, and don't know if this is optimal but I use it a lot and works for me.
------------------------------
eduardo valdes
------------------------------