Free Trial

Alteryx Designer Desktop Discussions

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

Unable to process xml file with a specific format in alteryx

ShruthiVijayaKumar
6 - Meteoroid

Hi Team,

 

I am unable to process the xml file with specific format as its throwing me error in structure but when i tried to process the sample xml solution is working in Alteryx.

 

<ide>
<cUF>15</cUF>
<cCT>00002041</cCT>
<CFOP>6352</CFOP>
<natOp>Prestacao de servico de transporte a estabelecimento industr</natOp>
<mod>57</mod>
<serie>149</serie>
<nCT>xxxx</nCT>
<dhEmi>xxxx</dhEmi>
<tpImp>1</tpImp>
<tpEmis>1</tpEmis>
<cDV>3</cDV>
<tpAmb>1</tpAmb>
<tpCTe>0</tpCTe>
<procEmi>0</procEmi>
<verProc>04.00</verProc>
<cMunEnv>1501501</cMunEnv>
<xMunEnv>Benevides</xMunEnv>
<UFEnv>PA</UFEnv>
<modal>01</modal>
<tpServ>0</tpServ>
<cMunIni>xxxxxxx</cMunIni>
<xMunIni>Paragominas</xMunIni>
<UFIni>PA</UFIni>
<cMunFim>xxxxx</cMunFim>
<xMunFim>Curitiba</xMunFim>
<UFFim>PR</UFFim>
<retira>1</retira>
<indIEToma>1</indIEToma>
<toma3>
<toma>3</toma>
</toma3>
</ide>

 

Please let me any answers ASAP ,Thank you in advance for 

 

Regards,

Shruthi.V

 

 

5 REPLIES 5
ChrisTX
16 - Nebula
16 - Nebula

Please provide additional information

 

unable to process the xml file with specific format: which tool(s) are you using?  please post a sample workflow

 

its throwing me error in structure:  what is the error

 

when i tried to process the sample xml solution is working:  what is "sample xml"?  please post a sample workflow

 

Please let me any answers ASAP:  please take some time to formulate a question with enough information, so someone can help you.

 

OTrieger
12 - Quasar

@ChrisTX  is right.

I took the text that you share and I'm getting a proper xml file without any structure issues.
x.PNG

ShruthiVijayaKumar
6 - Meteoroid

unable to process the xml file with specific format: which tool(s) are you using?  please post a sample workflow-I am using input tool and later xml parse tool, but in the input tool I am selecting type as xml and try to run it

 

its throwing me error in structure:  what is the error-Means i require all the sub directories or child nodes values

 

when i tried to process the sample xml solution is working:  what is "sample xml"?  please post a sample workflow.

 

<root>
<person>
<name>John Doe</name>
<age>30</age>
<email>john.doe@example.com</email>
</person>
<person>
<name>Jane Smith</name>
<age>25</age>
<email>jane.smith@example.com</email>
</person>
<book>
<title>The Adventure Begins</title>
<author>Robert Johnson</author>
<year>2022</year>
</book>
</root>

 

Regards,

Shruthi.V

 

 

 

 

ShruthiVijayaKumar
6 - Meteoroid

Can you please share me the snapshot of the data so that i can see how the child values are coming it and please help me out to get the same output

OTrieger
12 - Quasar

@ShruthiVijayaKumar 

Instead of inputting it as XML, you can importing it as csv file, do what ever you want  and then save it back as xml with new data

Labels
Top Solution Authors