Concatenate two tables Qlik Sense

[MarioCenteno]

I have two tables, but in table1 I have the id_client then I would like the data in table2 to be loaded based on the client_id of table1 How could I do this in the script of my app?

In my table2 I have the purchases of the client and in the table1 general data of the client.

[TABLE1]:

select id_client,name from table1;

[TABLE2]:

select id_client, sales from table2;

[Quy_Nguyen]

Try:

Select id_client, name

from table 1;

Join

Select id_cilent, sales

from table2;

You can consider join/left join or right join based on your need.