How can I filter a table to only show me the repeating field1 records
Products ----------------- filter -------------- Resulting table
field1 field2 field1 field2
1 3 2 4
1 4 5 4
2 4 6 3
3 3
3 4
5 4
6 3
Solved! Go to Solution.
Hi @bitgalicia ,
try this below:
ClearCollect(colls1,GroupBy(collSampleData,"Field1","Field2")); // dummy collection for grouping
ClearCollect(colls2,AddColumns(colls1, "Count", CountRows(Field2)) ,GroupBy(collSampleData,"Field1","Field2")); // dummy collection for count the repetation
Clear(collFinal);//Final collection with the desired output
ForAll(Filter(colls2,Count=1),Collect(collFinal,{Field1:Field1,Field2:First(Field2).Field2}));
Clear(colls1);
Clear(colls2);
In the above code, collFinal has the required output.
Note: I have tested this thoroughly and it is working seamlessly as expected.
I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.
Regards,
Krishna
If this post helps you give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.
Hi @bitgalicia ,
I just want to follow up with you on this issue to see is it resolved or still you see any challenges.
If you see any challenge/need further help let me know I am always happy to help.
Regards,
Krishna
If this post helps give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more
Hi @bitgalicia ,
I just want to follow up with you on this issue to see is it resolved or still you see any challenges.
If you see any challenge/need further help let me know I am always happy to help.
Regards,
Krishna
If this post helps give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more
Thanks for giving me the solution.It works perfectly. Regards
Hi @bitgalicia ,
try this below:
ClearCollect(colls1,GroupBy(collSampleData,"Field1","Field2")); // dummy collection for grouping
ClearCollect(colls2,AddColumns(colls1, "Count", CountRows(Field2)) ,GroupBy(collSampleData,"Field1","Field2")); // dummy collection for count the repetation
Clear(collFinal);//Final collection with the desired output
ForAll(Filter(colls2,Count=1),Collect(collFinal,{Field1:Field1,Field2:First(Field2).Field2}));
Clear(colls1);
Clear(colls2);
In the above code, collFinal has the required output.
Note: I have tested this thoroughly and it is working seamlessly as expected.
I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.
Regards,
Krishna
If this post helps you give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.
Hi @bitgalicia ,
I just want to follow up with you on this issue to see is it resolved or still you see any challenges.
If you see any challenge/need further help let me know I am always happy to help.
Regards,
Krishna
If this post helps give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more
Hi @bitgalicia ,
I just want to follow up with you on this issue to see is it resolved or still you see any challenges.
If you see any challenge/need further help let me know I am always happy to help.
Regards,
Krishna
If this post helps give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more
Thanks for giving me the solution.It works perfectly. Regards
User | Count |
---|---|
257 | |
110 | |
97 | |
52 | |
39 |