Splitting a table at an unfixed row

[Anonymous]

Hello,

I am trying to make dashboards using datas which use a quite particular format.

Some of the tables I have contain two or three sub-tables, with the top row of the next ones being at the end. Those tables are technically updated in real time, but I get them each hour. The tables are empty at first but can fill over time.

For example :

There, I have a first table with my clients. I can get rid of the final line (or top row of the second table) using "Remove rows" on the last one, starting from the end, but...

If the second table get updated, it won't be accurate anymore.

And as the number of rows at the end can vary, I have no idea on how to split correctly this table. I have the same problem for the first table, whose length can also vary (if we had new clients for exemple).

So, if you have any idea on how to solve this, could you please help me ?

Thanks !

[serpiva64 · Accepted solution]

Hi,

you can take a look at the attached file

first duplicate twice your query

Now use one query to find the position of Client in the list, by duplicating the query, drill down on the column and then utilizing List.PositionOf

Then you can use one query to keep top rows 

use the UI to write the step for deliting 1 row then substitute in the formula bar 1 with Position (the result of the first query)

use position -1 

then do the same to remove top rows

If this post isuseful to help you to solve your issue consider giving the post a thumbs up and accepting it as a solution