Is there any way to filter a table excerpt include that contains multiple elements from different pages?
e.g. I have 5 pages, all that have a "table excerpt" macro called "last_run_date"
On another page I use the "table excerpt include" macro looking for a macro called "last_run_date" across parent + all child pages which includes all those 5 pages and I get an outcome like:
08/10/2023
10/11/2023
11/11/2023
02/01/2024
20/02/2024
Which makes it seem like the one macro pulls the data for all of those individual macros and just adds them together. It also seems to do it in order of the oldest page to newest page such that the most recent is at the bottom.
What I really want from that list is just the last date. Is there any way to do this? I've tried putting the data into a table cell and filtering or transforming but even like
select T1.max(last_run_date) from T*
errors. I guess due to the fact that it's a single row with multiple values rather than multiple rows. It would be really great to only get the latest value... is it possible?
Hi @Scott Dyer ,
Sorry, didn't quite got the case - these five dates are pulled from five different pages, you ticked the "Show as a report" option in the Table Excerpt Include macro and now on the master page you see smth like this:
But you want to show not the whole table but the row where the date is the latest?
What do you mean that "it's a single row with multiple values rather than multiple rows"? It contradicts with the first part of your question.
Maybe you can give us a screenshot of your tables within the Table Excerpt macro and what you get after the Table Excerpt Include macro.
Your reply was helpful, it made me realise that in trying to test using this as a solution, I wasn't putting the initial data into a table, it was just text.
Once I put the data into tables, even tho they have the same name they just become rows in table with the same column heading and I'm able to transform them correctly.
Thank you!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.