Skip to main content
Question

What would be the best approach to pulling attributes from very large xml BLOBs from a SQL Table into able attributes and values.

  • August 18, 2023
  • 0 replies
  • 8 views

Forum|alt.badge.img

Hello. I have been tasked with pulling a large amount of XML from BLOB fields in a table to find relationships between the data. The problem I'm having is every approach I've tried has stalled FME Because of the large number of attributes I'm pulling out of the XML after XMLFlattener and AttributeExposer. I have attached one blob field, and each of them are basically the same, just larger or smaller. The results I'm picturing in my head are grouped by the Equipment GUID and Cable GUID.