topic Set Analysis problem with Rest connector in App Development

Set Analysis problem with Rest connector

Mon, 04 Apr 2016 11:48:49 GMT

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

Re: Set Analysis problem with Rest connector

Mon, 04 Apr 2016 12:45:53 GMT

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.

Re: Set Analysis problem with Rest connector

Mon, 04 Apr 2016 12:54:33 GMT

Hi Rohit,

Try using Generic Load for this.

Regards,

Rohan

Re: Set Analysis problem with Rest connector

Tue, 05 Apr 2016 05:06:44 GMT

Thanks Andrew, This is really helpful . Awesome job.

Re: Set Analysis problem with Rest connector

Tue, 05 Apr 2016 15:39:42 GMT

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