How to enter a new line in the XML file

[ppr (Peter Preuss)]

@gokul1904
Kindly note that XML Namespaces are to handle:

XML Extraction - Handling Namespaces (Tableau, Soap, OASIS types)

Going ahead Serializing the XML - output: xDoc | DataType: XDocument: [grafik] Checking if we have to handle XML namespaces [grafik] We do have: [grafik] Checking for some children: [grafik] Defining Namespace Variable [grafik] In some cases, we can also do: Assign Activity - xnsDefault = xDoc.Root.Name.Namespace Checkin the retrieval [grafik] xDoc.Descendants(xnsDefault + "productVersion") GetDescendants { [<productVersion build="456" xmlns="http://tableau.com/api">123</…

Let us show some building blocks at some sample data

Variables:

And an initial flow:

retrieve the element where later to add the new XElements:

xeLineReplacement = xDoc.Root.Descendants(xnsWD + "Invoice_Line_Replacement_Data").First()

Prepare the XElement which is to add:

newXElement = New XElement(xnsWD + "Quantity",1)

Add it:

Visuals:

the element knows its Namespace, but currently is not linked with the wd prefix

After Adding to the existing XML:

The wd prefix is in use

Afterwards save / process the XML as needed

Find starter Help here:
ppr_XMLWorkdayBox.xaml (8.1 KB)
Data.xml (240 Bytes)