Here's the scenario:
Excerpt macros dont seem to be able to capture the row from the child page,only one value from one cell. I'm trying to use the Table Plus macro but not having much luck there. Any suggestions? Any examples?
If you need to pull tables with more than one data row (Page Properties Report pulls only one data row from Page Properties), you can also use the combination of the Table Excerpt Include and Table Transformer macro. Table Excerpt Include provides an ability to pull any data (any size tables) from child pages, from specific pages, from pages by labels. Table Transformer merges all the tables in one.
Sorry for dragging this old topic to the surface again.
Above you mentioned "Unfortunately, there are no options to resolve this issue for now. We'll try to fix it shortly. I'll keep you posted on it."
Is this related to the issue of linebreaks getting lost when using the table transformer macro?
Because this is exactly the issue I'm currently struggling with. Is there any solution/workaround to solve this issue already?
(In all attempts I made to process the content of a table using SQL-query, the linebreaks are already missing in the string I'm trying to process)
Thanks in Advance
Unfortunately, we haven't found the solution after investigating the issue. But I've found a workaround. I'll describe it in the previous example with meeting notes.
1. Merge all the tables with a simple query: SELECT * FROM *
2. Wrap the Table Transformer macro with the Pivot Table macro.
3. Aggregate data by Date and use the Literal operation type.
4. Configure the Pivot Table macro: hide controls, totals, and the source table; set an appropriate Literal value delimiter.
Then you can rename the Literal of Notes column for a better view.
Please let me know if it helps.
Many thanks for your detailed explanation. Unfortunately this workaround doesn't help in my case.
I don't want to hijack this topic, but let me briefly summarize my issue:
I would need to process a multiline table cell within the SQL-query of Table Transformer, as I need to split each line into a separate cell.
This split works well with any kind of delimiter EXCEPT linebreak.
I spent hours trying to figure out what's the problem, until I found that the linebreak is apparently lost as soon as I "touch" the content of the cell in any way.
(actually even renaming the column during SQL SELECT i.e. " T1.'Items' as 'Renamed' " seems to cause the linebreak to be lost)
My hope was that there is some workaround I could use within the SQL query to replace the linebreak early-on with another delimiter that's not lost, so I can then process it normally a few lines later (I also tried SQL REPLACE to replace \n with another char but failed there as well).
Just for illustration, here's an example:
Table Transformer SQL-Query
RETURN(@a->Title as Title, _ as Items)
The query will split the "Items" into separate rows, which works great for other delimiters (like "x" in above example).
Unfortunately I don't have "x" in my actual table, I only have "\n" as delimiter...
--> Is there any SQL-command I might have missed which could "catch and replace" the \n into something else before the character gets lost?
Many thanks again
Sorry to again hijack this question.
I have a problem similar to @Christoph Marschall 's comment.
I have a bunch of Risks and their Linked Issues that I'd like to separate them into individual rows. For example:
I'd like the SQL to transform the table into:
The Linked Issues have "," (comma) as their delimiter.
I have tried Pivot table but it doesn't work in this case.
@Natalie Paramonova _Stiltsoft_ and Christopher, do you have any ideas on how I can write the SQL for this case?
Thank you so much really appreciate it.
Hi @Katie L ,
Please check this recent question - the last answer given by me on the 17th of September. The first three screenshots relate to your case - a similar table wrapped into the Pivot Table macro (through the Table Toolbox macro cause it is Cloud and we had nested macros) and the two screenshots of the Pivot Table macro settings.
If the Pivot Table still freezes your page, please raise a support ticket here. We'll try to investigate the issue. As for now we couldn't reproduce it for our test instance.
Inside this table merger macro you could use the Excerpt Macro and Excerpt Include Macro to bring one piece of text (that is: the whole table) per page on the parent page. For multiple transclusions from one page or multiple pages you would need a third-party macro that supports multi-excerpt (I assume that adding a new Excerpt Macro for each new page is not feasible).
I'm not sure if this solution approach meets your third point (which I do not fully understand). But here we go ...
If you have a large number of pages to transclude from and a large number of tables you need to merge you'll need to check your performance requirements since the transclusion and merging takes place at request time.
Biased Alert: I'm one of the authors of the projectdoc Toolbox.
How about putting your data in an Excel spreadsheet? Each child page gets it's own worksheet. The parent page gets the combined data off a worksheet in the same file that combines all the data. Specific worksheets (pages) in the Excel file can be specified in the Office Excel macro on each page
...ossibility became true in a not too far future, project/space access would be left in the hands of all team members. Don't get me wrong: I'd love it! However, it would also be nice to have a way in which j...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events