Xml File Comparison

Hi,
I am trying to compare two xml files where under one parent tag we can have multiple child tags.
Please suggest how can I do that because using string function it will need a lot of coding effort to accomplish this thing.

Thanks,
Anjali

@anjalimishra,
if you load UiPath.Excel.Activities pacakage then you will have following activities to use for XML.
image

hope my inputs are useful

Hi,
How I can use these activities to compare my xml files?

thanks,
Anjali

Hi,
I dont get xml activity, instead having excel activities downloaded.

Thanks,
Anjali

You need a design to compare

As stated earlier in my ask, if I go one after another tag it will take a lot of time.
So please suggest a simpler way to do the same.

Thanks,
Anjali

Could you please let me know you want to compare parents nodes or child nodes?

Set xmlDoc1 = CreateObject(“Msxml2.DOMDocument”)
xmlDoc1.load(“C:\Filepath\file1.xml”)’file 1

Set xmlDoc2 = CreateObject(“Msxml3.DOMDocument”)
xmlDoc1.load(“C:\Filepath\file2.xml”)’file 2

Compare in if else condition.

Hope this logic useful for you

If no other way try DataSet and see if you are able to compare(datatable columns) easily with that.

image

Hi,
I am getting below error
“Dataset does not have a public instance method name ‘ReadXml’”

image

xmlToDt.xaml (6.1 KB)

This is done for one XML file how can we achieve this for two or more XML files in the same workflow?

in UiPath using which activities we can achieve this?

Thanks,
Anjali

On the activities type “Assign” you will get assign activity. Please use that to create

Hi,
Assign activity can be used for
Set xmlDoc1 = CreateObject(“Msxml2.DOMDocument”)
then how can i do
xmlDoc1.load(“C:\Filepath\file1.xml”)’file 1??

Try in the same Assign activity

Hi,

I wanted to ask I’ve already installed UiPath.Excel.Activities (version 2.0.6526.16321), however, the activities like ‘Get XML Nodes’ and ‘Get XML node attributes’ were still unavailable. I;m using the UiPath Community Studio version 2017.1.6522. How do I make the activities like ‘Get XML Nodes’ and ‘Get XML node attributes’ available?

Thanks.

Can you share your manage package screenshot showing Excel Activities package.

@anjalimishra have you found the solution?