Hi community
i am having a challenge in the past few days which i cant find a solution. i have read previous post in regards with adding a related table within survey123 but in my case i need and FME workspace to read a spreadsheet saved in shared folder and create two layers.
One called 'Poles' (point feature).
Second is called 'Defect' and its a simple table.
The plan is that this spreadsheet is due to additional records from various sources, its a dynamic dataset and not a static which i could potentialy bring in Arc Pro and establish all the relations.
Not sure which path to follow.
The idea is to find on a field map the relevant pole, then open survey123 and work on the table.
Any ideas?