In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

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
Top Solution Authors