Pick 1 column each from 2 files and count the combination in 3rd file

Question

Hi Team, I have   3 files and I am trying to achieve the following

File 1

File 2

File 3

Expected :  Take ID from File 1, Find count of  distinct 'Grades'  - 'ID' combination in File 3 for all the  'Grades' that appear in File 2. All the columns from File 1 are to be retained with a new 'Count' column added.

sdesabhatla · Answer

Perfect, Thank you!! it resolved the issue.

atcodedog05 · Answer

Hi @sdesabhatla

Did it solve the usecase if yes please mark the post as solution. If no let me know whats the issue and how i can help you 🙂

atcodedog05 · Answer

Hi @sdesabhatla

Here is a workflow for the task.

Output:

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

apple.yxmd