Merging two tables using two keys

[johnnyjohn]

I am loading two tables from Mongo. The script is generated automatically by Qliksense

LOAD _id,
bin_idx
bins;

[bins]:
SELECT [_id],
[bin_idx],
[bins]
FROM testdb.[bins];

LOAD _id,
time_series_idx,
time_series;

[time_series]:
SELECT [_id],
[time_series_idx],
[time_series]
FROM testdb.[time_series];

How can I put [time_series] and [bins] into one table, so that the time_series and bins are on the same line if the [_id] is the same in both table and time_series_idx and bin_idx are the same?

[dplr-rn · Accepted solution]

just choose the right join based on your data/need

e.g. 

left join (bins)

LOAD _id,
time_series_idx,
time_series;

[time_series]:
SELECT [_id],
[time_series_idx],
[time_series]
FROM testdb.[time_series];

https://community.qlik.com/t5/QlikView-Creating-Analytics/Understanding-Join-Keep-and-Concatenate/td...