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.

[fsim · Accepted solution]

Can you run this query in the Confluence Database and provide us with the output? It looks like an indexing problem.

SELECT * FROM CONTENT WHERE CONTENTTYPE = 'USERINFO' AND USERNAME = '<username>';

Replace <username> with the user's username. This will help us identify the issue.

Make sure that the user has logged in at least once to Confluence, and that you have tried to Rebuild the Content Indexes from scratch

[Deleted user]

He hadn't logged in to Confluence yet (only JIRA). Once he did and indexes were rebuilt all works as expected.

Thanks