Merging two tables using two keys

johnnyjohn — Sat, 16 Nov 2024 02:52:57 GMT

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?

Re: Merging two tables using two keys

dplr-rn — Wed, 25 Mar 2020 18:40:39 GMT

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-p/328379

topic Re: Merging two tables using two keys in App Development

Merging two tables using two keys

Re: Merging two tables using two keys