use field from first table to extract a second table

[sylvain_piccarreta]

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

[rubenmarin · Accepted solution]

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