use field from first table to extract a second table

sylvain_piccarreta — Sat, 16 Nov 2024 00:46:20 GMT

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

Re: use field from first table to extract a second table

rubenmarin — Mon, 27 Apr 2020 10:50:24 GMT

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

topic Re: use field from first table to extract a second table in QlikView

use field from first table to extract a second table

Re: use field from first table to extract a second table