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 parsin...
vkandalam's avatar
vkandalam
New Contributor II
3 years ago

Hi @AleksandarAngelevski Thank you for your reply. This will solve the issue at this stage, but I am going to have a few more calls to other databases and child pipelines and after making these calls I will need to be able to access the information that i had in the previous snaps or the data that was generated in child pipelines. It won’t be in a linear function. Any snap that i can use which will give me access to data which was generated in any snap in this execution context?

Aleksandar_A's avatar
Aleksandar_A
Contributor III
3 years ago

You might consider this approach:

But you have to be aware of the data size, because the Gate Snap keeps the data in memory which can lead to high memory usage of the snaplex.

BR,
Aleksandar.

  • rashmi's avatar
    rashmi
    New Contributor III
    3 years ago

    PIMData.txt (1.8 KB)

    hi @bojanvelevski i was trying to frame that structure will share the sample input and xsd pls could u help pls
    samplerecords.json (262 Bytes)
    Please convert PIMData.txt to PIMData.xsd as the template is in that format
    Please also find output expected xml in txt format
    outputxml.txt (3.2 KB)

    • alchemiz's avatar
      alchemiz
      Contributor III
      3 years ago

      Hi rashmi,

      Good day, instead of using an xml generator snap have you tried the xml formatter? I don’t know if this is your required output but xml formatter accepts an outgoing format as XSD

      XML output using PIMData.xsd

      Updates:

      ,

      I’m not that familliar with XSD so I manipulate the sample input using a mapper snap, attached poc pipeline

      canvas 15_2022_12_03.slp (16.8 KB)

      Thanks,
      EmEm