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