how we validate clob Data like Message, XML and Json format.

[rohit782192]

Please help me with a workflow on how we work in creation of Alteryx clob Data like Message, XML and Json format

[BrandonB · Accepted solution]

JSON Build tool for the creation of JSON: https://community.alteryx.com/t5/Engine-Works-Blog/JSON-Build-Tool/ba-p/154227

XML Output tool for the creation of XML files: https://gallery.alteryx.com/#!app/XML-Output/565bfd4caa690a12542665e3

[rohit782192]

Hi Brandon,

My input is from a DataBase1 in json and XML format and i need to validate in Database2 the same has been migrated properly or no.

How would use this as a approach.

The solution you provided is to convert rows and column to json format.

I need a reverse format to compare two Database. 

[BrandonB · Accepted solution]

We also have the XML Parsing tool which can be found in the parse category. 

https://help.alteryx.com/current/designer/xml-parse-tool

If it is a simple xml file this should be straightforward, but if there are multiple nested layers there are some more techniques that can be used. The XML parse tool should allow you to convert XML to a flatter structure which can then be compared against another source. 

[rohit782192 · Accepted solution]

What about Json message.

[BrandonB · Accepted solution]

The JSON Parse tool can be used to parse JSON fields: https://help.alteryx.com/current/designer/tools/developer/json-parse-tool