Combine Series to Row and Merge Transformations

[kyledavidstewart]

Hello,

I have two tables that utilize ‘Series to Row’ to format the table (see picture):

Table 1 has columns Time and Val1, Table2 has columns Time and Val2. I would like to merge these tables to one table with columns Time, Val1 and Val2.

I cannot figure out how to do this merge.

When I use both queries in the table, I end up with the following table that only has two columns:

Any guidance on how to properly due the merge described above would be appreciated.

Thank you

[mattabrams]

Hi @kyledavidstewart ,

I believe you are looking for the outer join transformation.