Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have 2 tables. I need to extract the first table (with REST connector) to have the ID needed for the secont extract (with REST connector). How can I do it ?
example :
//first extract
CUSTOM *****
LOAD ID,
COUNTRY
from table1;
//second extract, I need to boucle on the each ID
For Each var in ID
CUSTOM ****$(var)****
LOAD NAME, JOB, STATE
from table2;
next var;
thanks for your help
Hi, this blog post can help you to know how to make dynamic REST connections:
https://community.qlik.com/t5/Qlik-Design-Blog/REST-connector-Using-WITH-CONNECTION/ba-p/1523257
Hi, this blog post can help you to know how to make dynamic REST connections:
https://community.qlik.com/t5/Qlik-Design-Blog/REST-connector-Using-WITH-CONNECTION/ba-p/1523257