Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
sylvain_piccarreta

use field from first table to extract a second table

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

Labels (2)
1 Solution

Accepted Solutions
rubenmarin1

1 Reply
rubenmarin1

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