12-01-2022 10:35 PM
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
12-02-2022 11:30 PM
@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??
Please could you help
12-06-2022 04:50 AM
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)
canvas 15_2022_12_03.slp (7.2 KB)
Thanks,
EmEm
12-06-2022 04:54 PM
@alchemiz Thanks a lot 🙂