4 Replies Latest reply: Apr 5, 2016 11:39 AM by Andrew Mein RSS

    Set Analysis problem with Rest connector

    Rohit Kumar

      Hi ,

      I have made a connection with the help of Rest Connector and got three columns from there Key, Val, Content in the format below:

       

      Key        Value      Content

      1           Name       David

      1           Amount     100

      2           Name       bruce

      2           Amount     200

      3           Name       Tony

      3           Amount     300

       

      so when i select Key=1 and Value=Name then content will come David in dashboard KPI (if(val='Amount',content) )

       

       

      The requirement of my business is to make a table before start the visualization work is in below format

       

      Key  Name     Amount

      1      David        100

      2      Bruce        200

      3      Tony         300

       

      Can you please tell me how to remodel the structure of data data which is coming through API