Can I populate 1 column in a table with data from a different table?

Lisa Hooper_ud4lyh

I have a RAG status table with data that looks like Table 1 below. I have another table in a tab on the same page that looks Table 2 below. Can I have the January column in Table 1 be populated by the values in the Status column in Table 2?  

Last question is can I have the value of G color the cells with a green background automatically? 

Thanks for any help!

 

 

Katerina Kovriga {Stiltsoft}

Hi @Lisa Hooper ,

We can suggest trying our Table Filter and Charts for Confluence app.

At first you may reuse these tables using the Table Excerpt/Table Excerpt Include macros (especially the second one - it is very convenient if your source tables are placed on different pages). For simplicity, I've placed them on the same page - the first step is to wrap your tables (reused or not) into the Table Toolbox macro:

The second step is to wrap your tables into the Table Transformer macro inside the Table Toolbox macro and use the following customized SQL query:

SELECT *,
FORMATWIKI("{cell:bgColor=" +
CASE WHEN T2.'Jan, 2022' LIKE "G" THEN "#abf5d1"
WHEN T2.'Jan, 2022' LIKE "Y" THEN "#fff0b3"
ELSE "#ffbdad"
END
+ "}" + T2.'Jan, 2022' + "{cell}")
AS 'Jan, 2022'
FROM T1 OUTER JOIN T* ON T1.'Metric' = T*.'Metric'

This query allows us to look up tables by the unique "Metric" column and color the cells' background based on the status for the "Jan, 2022" column.

As a result, we'll see the following table:

Then we wrap the Table Transformer macro into the Table Filter macro, hide the unwanted columns and filter the combined result table, for example, by statuses:

Hope this helps your case.