Forum Discussion

rashmi's avatar
rashmi
New Contributor III
3 years ago

Excel columns to xml using paticular xsd

Hi All,
I had parsed the excel sheets which is required and got the columns and rows need to convert to xml with xsd as shown below

B & C are columns of one excel sheet after parsing

pls could any one help how incoming data should be structured/framed(Json format) to satisfy this condition in xsd

Any help is appreciated.

cc: @dmiller, @koryknick, @ptaylor, @bojanvelevski, @siwadon, @del

7 Replies

  • tstack's avatar
    tstack
    Former Employee

    You could also concatenate the two arrays together and then use a single JsonSplitter on the resulting array:

    $TransactionItems.concat($TransactionMedias)
    

    The Copy/Union can also be removed then as well.

  • arvindnsn's avatar
    arvindnsn
    Contributor

    Thank you for the Solution. That works and helps.