Merging two queries from different datasource

Hello,

I have on query from a MS-SQL database that has the following format:
TIME, TAG, VALUE

And another query from Postgresql that has the format:
TAG, TYPE, MODEL

I would like to merge both of them, but using the merge transformation I only merge one row.

Example:

TABLE A
TIME,TAG,VALUE
2021-01-01 00:00:00,“MY TAG”, 10
2021-01-01 00:00:01,“MY TAG 1”, 10
2021-01-01 00:01:00,“MY TAG”, 10

TABLE B
TAG,TYPE,MODEL
“MY TAG”,“TYPE A”,“MODEL A”
“MY TAG 1”,“TYPE B”,“MODEL B”,
“MY TAG 2”,“TYPE C”,“MODEL C”

Expected results:
2021-01-01 00:00:00,“MY TAG”, 10,“TYPE A”,“MODEL A”
2021-01-01 00:00:01,“MY TAG 1”, 10,“TYPE B”,“MODEL B”
2021-01-01 00:01:00,“MY TAG”, 10,“TYPE A”,“MODEL A”

Actual results:
2021-01-01 00:00:00,“MY TAG”, 10,“TYPE A”,“MODEL A”
2021-01-01 00:00:01,“MY TAG 1”, 10,“TYPE B”,“MODEL B”
2021-01-01 00:01:00,“MY TAG”, 10
,“MY TAG 2”,,“TYPE C”,“MODEL C”

The second “MY TAG” entry has no data from Table B.

Any solution possible?

Thank you,
pvmagacho

Hi,

Please have a look at this thread :

The current joint possible is what you get.

You can always apply for a feature request in GitHub.

Hope it helps.

Good Luck