How to make the code less redundant xml

[ppr (Peter Preuss)]

@sereganator
maybe you can share the exact element name of the two xml structures on where you want to avoid redundancy.

However there are a few options, that can be checked:

• extract Workflows / seperate XAML for each structure type: KZVU, KVOKS

• invoking the relevant branch can be done by a switch statement reacting on Root Elementname or defaultnamespace (was answered in one of your others topics)

• writing generic retrievals with an injected namespace variable like:

  • first check which structure type you have to process (see above: switch)
  • currentNameSpaceVar = nsVarX
  • retrieval: xDoc.Root.Descendants(currentNameSpaceVar +“Elementname”)(0)…

For setting up retrievals with XPath have a look here (was already shared with you in one of your others topic):

Reading all the tags of an XML and take them to excel

@Fabian_DDD I do feel that a XPath Approach is better for the retrieval Setting up a NamespaceManager with a Config Datatable: [grafik] for the default namespace with empty prefix “def” is assigne as prefix the retrieval is configured as another datatable (could also be externalize into an excel) [grafik] I did also for a deeper nested element for demo purpose After all preperation it is iterating over the retrieval config and retrieves the specfied values. et voila: [grafik] So this …

Do some exploration of the String.Format method as well. Could be used as e.g:
String.Format("//{0}:ElementName", varCurrentPrefix)

Also have a look on how to formulate the retrieval with local name only:

How to create dynamic xpath with namespace for xml value

@hellitonwoo Give a try on Something Like this xpath: “string(//*[local-name()=‘YourElementName’]/text()[1])” would return the value. Just to Show in how to Deal with xpath and localname in namespace used scenario

//*[local-name()='Element1']//*[local-name()='Element2'] .....

how to refer to an element within an element, and then to its attribute.

in general: xDoc.Root(xnsVar + “ParentElementName”)(0).Element(xnsVar + “ChildElementName”).Attribute(“AttributeName”).Value