Hi,
I have data in below format extracted from Hubspot's API using REST connector.
![dd.JPG dd.JPG](https://community.qlik.com/t5/image/serverpage/image-id/6835i21EBAB8543CA5DED/image-size/medium?v=v2&px=400)
![visd.JPG visd.JPG](https://community.qlik.com/t5/image/serverpage/image-id/6833i50079C28088EDDAE/image-size/large?v=v2&px=999)
Now what i need to do is model the data to make a simple table of all records. In this table the Unique KEY is vid but i somehow not being able to sort this data out.
Here's what i am expecting as a result:
![ressssss.JPG ressssss.JPG](https://community.qlik.com/t5/image/serverpage/image-id/6836i6CA597B7FA8ACD79/image-size/large?v=v2&px=999)
Any Idea how to get this done?
Thanks
Pankaj