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.

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Sami Ullah 315 Moderator on at

Like (2)

Report
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.

Was this reply helpful? Yes No
PowerLiebhaberi 9 on at

Like (0)

Report

Thank you so much :-)

Was this reply helpful? Yes No