cancel
Showing results for 
Search instead for 
Did you mean: 

Excel columns to xml using paticular xsd

rashmi
New Contributor III

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

community1

community2

B & C are columns of one excel sheet after parsing
community3

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 7

rashmi
New Contributor III

@bojanvelevski @alchemiz thanks a lot!! but one thing is how can we add id(which is dynamic) & translatable=“yes” which is constant for first column and translatable="no " which is constant for second column wanted to add attribute to even columns like how u added id attribute to row??
image

Please could you help

Hi Rashmi,

Here’s an updated poc pipeline where I did some object manipulation to set col attributes id and translatable

For setting up an attribute in an object key name should start with ‘@’ then set the node value to ‘$’

I use regex to determine if col value is translatable or not e.g. value.match(/[a-z]/gi)

image

canvas 15_2022_12_03.slp (7.2 KB)

Thanks,
EmEm

rashmi
New Contributor III

@alchemiz Thanks a lot 🙂