Answered

Remove records from collection if condition

(1) Share

Report

Posted on by PowerLiebhaberi

Hi everyone,

I have a collection in my App. It has four columns - Date, Person, number and created. Acually it has more columns, but basiclly it looks like below:

Date Person created

01.01.2023 Michael 01.02.2023

01.01.2023 Michael 01.03.2023

01.01.2023 Michael 01.04.2023

01.01.2023 Michael 01.05.2023

01.01.2023 Michael 01.06.2023

01.02.2002 Michael 01.06.2023

01.01.2023 Anna 01.02.2023

01.01.2023 Anna 01.03.2023

01.02.2002 Anna 01.06.2023

I'd like to count the rows of each person with the same date. If it's even, remove all records, if uneven, save only the the last created and remove the others. The result should look like this:

Date Person created

01.01.2023 Michael 01.06.2023

01.02.2002 Michael 01.06.2023

01.02.2002 Anna 01.06.2023

Does anyone has an idea?

Thank you.

All responses (2)

Answers (1)

PowerLiebhaberi 9 on at

Like (0)

Report

Remove records from collection if condition

Thank you so much :-)
Verified answer

Sami Ullah 284 on at

Like (2)

Report
Remove records from collection if condition

Hi, Please Try This.

ClearCollect( GroupedCollection, AddColumns( GroupBy( MyCollection, // your collection name. Date, Person, GroupedRecords ), RecordCount, CountRows(GroupedRecords), created, Last( SortByColumns( GroupedRecords, "created", SortOrder.Ascending ) ).created ) ); ClearCollect( FinalCollection, ForAll( GroupedCollection, If( Mod( RecordCount, 2 ) = 1, // checking is odd count. ThisRecord ) ) );

I have verify with your data.