Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

XML Output - Remove extra quotation marks

HenpetsGordres1
8 - Asteroid

I have a workflow which merges 2 XML files, the issue at present is that the output is appearing like this (X in place of data which can't be shared):

 

"<?xml version=""1.0"" encoding=""UTF-8""?>"
<root>
<child>
<entries>
"<Country=""XX"" Type=""XXXXX"">"
"<Name=""XXXXXXXXXX"" />"
</entries>

</child>

</root>

 

Extra quotation marks (") are being output before and after, as well as within, the Country and Type Name subchilds and also on the first line before, after and within: <?xml version...

 

It should be appearing like this:

 

<?xml version="1.0" encoding="UTF-8"?>
<root>
<child>
<entries>
<Country="XX" Type="XXXXX">
<Type Name=""XXXXXXXXXX"" />
</entries>

</child>

</root>

 

I can't use a find and replace, as all will be removed and can't actually see this happening before the output tool:

 

Untitled.png

 

Why would the Output contain these extra quotation marks? Is there any tool which I could use to remove them?

 

Many thanks

 

 

 

 
 

 

 

1 REPLY 1
Jonathan-Sherman
15 - Aurora
15 - Aurora

Hi @HenpetsGordres1,

 

In your output tool you need to use the "Never" dropdown for the Quote Output Fields option.

 

image.png

 

If this solves your issue please mark the answer as correct, if not let me know!

 

Regards,

Jonathan

Labels