data for app

tmullins
tmullins Houston, TX 🟠

I have a dataset with historical production data by month that I am using in an app.  I need to restructure the data so that the monthly values are nested into new objects based on their CISN which is a unique identifier.  I have been able to create the nested production data as hoped but it is still returning every row for each CISN.  I have attached the code that I am using for the data pull.  As a footnote, I am a novice with JavaScript & jQuery so I am not sure if I am on the right track or way off base with the code I have used.

 

Any suggestions/help would be greatly appreciated!!

 

Sample of the data in tabular format looks like this:

table.png

 

and produces the following json structure when loaded via domo.get:

json.png

Nested json production example:

nestedJson.png

 

Comments

  • Great question.

     

    This will require working with your CSM in this particular case.

     

    @SpencerWilcox please touch base with @tmullins on this question.

     

    Thanks!

    Dani aka "Mr.Dojo"

    Dojo Admin
    **Say "Thanks" by clicking the "heart" in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"
    **You can update your Dojo Community name and avatar by clicking on your avatar then the "My Profile" button.