How to enter a new line in the XML file

[gokul1904 (Glory 01)]

Hi team ,

I want to enter the highlighted 3 lines again below in the xml file .
For eg like this -

Please find the original snapshot of the file for your reference.Also I have attached the xml.

MAIN_FILE - Copy.xml (3.7 KB)

Can you please help me in entering the 3 lines ?

Thanks,
gokul

[marian.platonov]

Check if this post it is helping you: How to add dynamique element on existing XML file - #6 by ppr

[gokul1904 (Glory 01)]

I tried but I am not able to find the solution.

Regards,
Gokul

[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)

[gokul1904 (Glory 01)]

Thank you for the help.

Regards,
Gokul