Prototype for https://knowledge.safe.com/questions/88427/using-xfmap-to-create-multiple-values-for-one-attr.html

100%

Prototype for https://knowledge.safe.com/questions/88427/using-xfmap-to-create-multiple-values-for-one-attr.html

✓ Published0🌍 Public

Last edited Mar 14, 2019

Created on Mar 13, 2019

This prototype demonstrates how to use FME’s XML reader with an XFMAP (XML Mapping File) to flatten nested XML data into multiple attributes on a single feature. The workspace reads an XML dataset, exposes a set of FME-specific and XML-derived attributes, and includes parameters for configuring feature types, dataset paths, and XML parsing options. The visualization shows how the XML structure is transformed through the mapping process, highlighting the attribute definitions and the generated feature types.

AI-generated description

Similar vizzes

Loading thumbnail…

Prototype for https://knowledge.safe.com/questions/88427/using-xfmap-to-create-multiple-values-for-one-attr.html

This prototype demonstrates how to use the XFMAP (XML Feature Mapping) to generate multiple attribute values from a single XML source within an FME workspace. It reads an XML file, parses its structure, and produces features with repeated attributes—enabling the transformation of nested XML elements into flat, multi-valued table rows. The workspace visually maps out the data flow with reader, transformer, and writer nodes, showing how list attributes and feature merging can be orchestrated to flatten hierarchical data. The visualization highlights the workflow logic, not the data itself, serving as a template for FME users seeking to handle similar XML-to-attribute transformations.

FFrieseWoudloper

97% match

Loading thumbnail…

Prototype for https://knowledge.safe.com/questions/88427/using-xfmap-to-create-multiple-values-for-one-attr.html

This prototype demonstrates how to use the XFMAP (XML Feature Mapping) technique in FME to expand a single XML attribute into multiple output attribute values. The workspace reads an XML source dataset and applies an XML mapping strategy to split or repeat values based on structure, showing how one input element can generate several output attributes. The visualization highlights the flow from the XML reader through the mapping logic to the resulting feature attributes, making it clear how repeated or complex XML content is transformed into multiple discrete attributes.

FFrieseWoudloper

95% match

Loading thumbnail…

Example workspace for https://knowledge.safe.com/questions/88158/extract-xml-data-from-an-access-database-table.html

This example demonstrates how to extract XML data stored in an Access database table and convert it into a well-formed XML document using FME. The workspace uses a Creator transformer to generate a feature, followed by an AttributeCreator to populate the `ReportDataXML` attribute with a static XML string. The key transformation involves cleaning the raw XML content—removing invalid characters, ensuring proper encoding declarations, and structuring it into a well-formed XML document. The workspace is configured with enhanced geometry handling and a straightforward linear flow, making it a minimal yet effective template for extracting and normalizing XML from database fields.

FFrieseWoudloper

63% match

Loading thumbnail…

fn:xml-to-json example

This example demonstrates the transformation of a nested XML document into JSON using the XQuery 3.1 function `fn:xml-to-json`. The XML input encodes workshop information, including leaders and institutions, within a structured `<map>` and `<array>` hierarchy using the XPath Functions namespace. The function converts this XML representation directly into its JSON equivalent, preserving the nested array and map structure. The code relies on the standard XQuery 3.1 function library, with the source document defined inline and the transformed JSON output returned as the query result.

CCliffordAnderson

52% match

Loading thumbnail…

FME workspace for https://knowledge.safe.com/questions/88318/api-watch.html

This example uses an FME workspace to demonstrate how to monitor an ArcGIS Open Data REST API for changes. A Creator transformer initiates the workflow, and an HTTPCaller sends a request to the API endpoint with query parameters for the catalog and page size. The workspace is designed to retrieve data from the specified ArcGIS portal, showcasing a pattern for API polling or scheduled data extraction within FME.

FFrieseWoudloper

51% match

Loading thumbnail…

Converts from XML to GEOJson

This example shows the conversion of a single XML item containing place-name, latitude, and longitude data into a GeoJSON FeatureCollection with a Point geometry. It demonstrates a direct data-shape transformation. The code constructs the output JSON structure explicitly, mapping the XML text value to a `properties` field and the numeric coordinates into a `coordinates` array. The conversion relies on the MarkLogic `json:serialize` function to produce the final GeoJSON output from the hand-built `json` element. The snippet does not include any rendering or mapping library.

CCliffordAnderson

50% match

Loading thumbnail…

Parse WFS response in R

This example demonstrates how to inspect a WFS service’s capabilities and identify its supported output formats and available feature types, along with the server’s maximum result limit. The R script uses the `XML` package to parse the `GetCapabilities` response from the Dutch national georegister’s CBS boundary service, applying XPath queries to extract `ows:Value` texts and `wfs:Name` entries. It also reads the `CountDefault` constraint to determine the per-request cap. The output shows the parsed metadata as character and integer vectors, revealing the service’s configuration without fetching any actual geographic data.

FFrieseWoudloper

49% match

Loading thumbnail…

Multi-Value Maps

This example demonstrates D3’s multi-value map syntax, which lets developers set multiple attributes or styles in a single call using an object literal. The visualization shows a scattered arrangement of ten semi-transparent circles placed at random positions and sizes on an SVG canvas, alongside a centered text label. The code uses `selection.attr` and `selection.style` with map arguments, and defines attribute values as constants or functions of data. It relies on d3.v3 and renders entirely through SVG elements.

Mmbostock

49% match