Table Transformer - Table merge with conditional column insertion

[Brad Johnson]

Hello All.

I have multiple pages, one for each project each containing two tables of data. I want to merge and transform the data into 1 consolidated table.

Table 1 has basic Project Info in Rows. 1 per project page.

Table 2 has Project timeline info in rows and columns. 1 per project page.

What I want is a single table reporting project information, 1 row per project (page) using values from the two tables per project page.

The project info is straight forward (first 5 columns) but I believe I need table transformer to add the timeline columns and populate the cells and that's where I am stuck.

Desired end result

I've had a bit of a go using examples but I'm not an SQL guy and I haven't seen an example that covers this. Any help would be appreciated.

Thanks in advance.

[Milo Test]

Sometimes view permissions can make a space invisible, even from a site admin.

Go image2015-8-5 13:52:57.png --> General configuration --> Space Permissions (under USERS & SECURITY) and see if it is listed there, and adjust permissions accordingly.

There were times, however, that I had to have Atlassian support grant me access to spaces in Cloud. The problem hasn't happened since we moved to Server.