Forum Discussion

marcelocastro's avatar
marcelocastro
New Contributor
6 years ago

create json struct - data rows

A data set (dataset source) that must be transformed into a json structure. How can this accomplish this using groovy or another tool? For each COD_DOC a JSON file with its associated items must be c...
  • marcelocastro's avatar
    marcelocastro
    6 years ago

    Hi Richie

    Thank you for your suggestion. I did the data conversion, but I did not find a way to group the items in a document.
    The answer I obtained was to convert each row of the table into a JSON structure, but what I need and am having difficulty is to group the item data of each document into a single JSON for each document.
    Thank you

     

richie's avatar
richie
Community Hero
6 years ago

Hey marcelocastro 

 

if you actually want to convert from .xlsx to .json in situ I can't help - but there's an online converter that might help - it converts from .csv to .json - I found it here

 

I also found a youtube vid on using javascript to do the job - here

 

Cheers,

 

richie

  • marcelocastro's avatar
    marcelocastro
    New Contributor
    6 years ago

    Hi Richie

    Thank you for your suggestion. I did the data conversion, but I did not find a way to group the items in a document.
    The answer I obtained was to convert each row of the table into a JSON structure, but what I need and am having difficulty is to group the item data of each document into a single JSON for each document.
    Thank you