How to 'join down'

Support and Helpdesk
1

Hello OR Community / Overmind,

I'm facing a challenge with some tables where the authors' information is split across multiple rows. I need to consolidate these values so that all data related to authors is combined into a single row, but the lowest instead of the highest one.

I might be missing an obvious solution, so I'd appreciate any assistance in figuring out how to achieve this.

joindown
joindown1920×1363 353 KB

2

Hi @archilecteur. I think the approach I'd take is:

  1. Add a column using "rowIndex" (e.g. from auteur column drop down do Edit Column -> Add column based on this column, expression rowIndex
  2. Do a reverse numeric Sort by this column
  3. Reorder rows permanently

Now the rows are in the reverse order you move the resume column to the beginning of the project and then use the usual "join multi-valued cells" to combine your auteur cells

Will that work for you?

1 Like
3

As always @ostephens, you've come up with a solution, if not an idea, to get the ball rolling again. From there, I was able to solve the problem. Many thanks to you.

1 Like
4

Can you show me example