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

    Set Analysis problem with Rest connector

      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