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...
Forum Discussion
Hi Roger667
I'm not sure of this behavior, I haven't faced this earlier and not able understand the issue. may be you can try copying the contents of the file in a new CSV and use it.
mapping CSV file is an option to convert the metadata, you can use an expression file also to achieve this. I found this easier and used this. but you can also maintain these details in an expression file and call it in a mapper to get the parquet appropriate data types.
Thanks !
Hi manichandana_ch
This error is comimg due to datetime data type in salesforce object which is mapped as bigint in the mapping sheet. But this mapping leads to loss of data and timestamp only comes as year. Can you suggest how to handle this datetime
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)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
