InfoAsset Planner - COF/LOF Wizard Pipe Inventory Table Join on Column other than FacilityID
During "Step 3 - Set Parameter (Pipe Inventory)" I would like to be able to join the Internal/External table using an InfoAsset Planner column other than the "FacilityID". For example it would be great to also have the option of using the "LegacyID" to join the data however the COF/LOF is hard-coded to only accept the "FacilityID".
It would be even better if any column could be used but that's probably not practicable given processing overhead and possible lack of data structure rules causing join errors. A handful of User Defined, ID columns would be great. These columns could then be used to join the "Data Source" to the relevant InfoAsset Planner column.
A couple examples would be: Where a Legacy ID is used to identify the asset
or where an external dataset identifies a group of assets (Location ID, Branch ID, Drainage Catchment etc.), essentially allowing a one-to-many join from within the wizard.
Bradley Nissley
shared this idea