Discussion board where members can learn more about Qlik Sense App Development and Usage.
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
Not really used REST connectors before, but can you change the load script to use the resident table:
FROM <REST Connector>;
Content AS Name
WHERE Value = 'Name';
Content AS Amount
WHERE Value = 'Amount';
DROP TABLE Data_Source;
Qlik will then join the two tables on the Key.
Try using Generic Load for this.
Thanks Andrew, This is really helpful . Awesome job.
Thank you - although Rohan's answer of a Generic Load is much cleaner!