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.
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 😀👍
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 🙂
Perfect, Thank you!! it resolved the issue.