Helping in Joining and summarizing

[Feras95p]

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.

[Qiu · Accepted solution]

@Feras95p 

An uniton tool will do the trick.

[Feras95p]

@Qiu @BrandonB  I couldn't open it due to the versions  😞

[Qiu]

@Feras95p 
what is your current version? I will match.

[Feras95p]

@Qiu 2019.4.6.2113

[Qiu]

Try this one. And please your Sample.xls in the same folder of the workflow.

[Feras95p]

@Qiu  Still the same issue.

[Qiu]

@Feras95p Thank you for the marking.