Set Analysis problem with Rest connector

[#1]

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

[#2]

Not really used REST connectors before, but can you change the load script to use the resident table:

[Data_Source]:

LOAD

     Key,

     Value,

     Content

FROM <REST Connector>;

[Names]:

LOAD

     Key,

     Content AS Name

RESIDENT Data_Source

WHERE Value = 'Name';

[Amounts]:

LOAD

     Key,

     Content AS Amount

RESIDENT Data_Source

WHERE Value = 'Amount';

DROP TABLE Data_Source;

Qlik will then join the two tables on the Key.

[#3]

Hi Rohit,

Try using Generic Load for this.

Regards,

Rohan

[#4]

Thanks Andrew, This is really helpful . Awesome job.

[#5]

Thank you - although Rohan's answer of a Generic Load is much cleaner!