How to merge rows with the same value

Hi all,

I'd like to have my data shown in a table like this:

Currently, it's:

Student A Subject D - Level 1

Student A Subject D - Level 2

Student A Subject E - Level 1


Inputs are greatly appreciated.

Thank you.

Hi! 

You can have a "If" to hide the the expression "Studant A" if the content is equal to the previous line.

Some thing like : 

(table.list.CurrentRowNumber=0 or 

 table.list.Current.Record.StudanteName <> table.list[table.list.CurrentRowNumber-1].Record.StudanteName)

If true show else hide. 

Hope this hlep

Graça


Hi,

If I understand what you need, you have to do something like this.

Create two entities Student and Subject.

Student entity fields id, name. Subject fields Id, StudentId, Description.

Create a table records to list students and create a web block to list subjects of a student. Then consume the web block inside the table records, one column to show student name and other to put web block to show student subjects.

If the data is on the same aggregator  you can use the list index to suppress the column with "Student A" whenever it matches the previous record. Something like this in the expression:


if( Table.List.CurrentRowNumber<>0, 
    if( Table.List[Table.List.Current].Title = Table.List[Table.List.Current-1].Title, "", Table.List.Current.Title))

Hi vincentf,

I made a sample app for you

Give me your feedback please

Regards

Tiago Queirós wrote:

Hi vincentf,

I made a sample app for you

Give me your feedback please

Regards


Hi Tiago,


It's close to what I have in mind, but why does Student B appear when it doesn't have any Subject?

Solution

vincentf wrote:

Tiago Queirós wrote:

Hi vincentf,

I made a sample app for you

Give me your feedback please

Regards


Hi Tiago,


It's close to what I have in mind, but why does Student B appear when it doesn't have any Subject?


Hi,
corrected

regards
Solution

Tiago Queirós wrote:

vincentf wrote:

Tiago Queirós wrote:

Hi vincentf,

I made a sample app for you

Give me your feedback please

Regards


Hi Tiago,


It's close to what I have in mind, but why does Student B appear when it doesn't have any Subject?


Hi,
corrected

regards

Hi Tiago,

Thanks for the help. I never thought of using a web block before.


vincentf wrote:

Tiago Queirós wrote:

vincentf wrote:

Tiago Queirós wrote:

Hi vincentf,

I made a sample app for you

Give me your feedback please

Regards


Hi Tiago,


It's close to what I have in mind, but why does Student B appear when it doesn't have any Subject?


Hi,
corrected

regards

Hi Tiago,

Thanks for the help. I never thought of using a web block before.


i´m glad to be able to help.

Good luck

Regards