Deal all,
I need your help, I stuck in the half of the workflow. What I'm having is that.
I have an excel file which contains of these columns:
Certificate Number: Which is a unique number represented a company.
City: It's clear.
Date: Which it's clear.
Code: This what I'm going to calculated my output depending on it.
What I'm looking to have in my output is that each company which is represented by certificate number I want to know which codes are using and how many times it used this code before 20-6-2020 and how many times it used the code at 20-6-2020 and after
So the output of the workflow should be like this for example:-
Whereas the input is

I have attached the excel file and the workflow where I left
.
It's urgent if someone can help it will be much appreciated.