Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

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

sdesabhatla
6 - Meteoroid

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

 

File 1

 

sdesabhatla_0-1604025393813.png

 

File 2

 

sdesabhatla_1-1604025465027.png

 

File 3

sdesabhatla_3-1604025691248.png

 

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_4-1604026022188.png

 

 

 

 

 

 

3 REPLIES 3
atcodedog05
22 - Nova
22 - Nova

Hi @sdesabhatla 

 

Here is a workflow for the task.

Output:

atcodedog05_0-1604038047182.png

 

Workflow:

atcodedog05_1-1604038059103.png

 

 

Hope this helps 🙂


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

atcodedog05
22 - Nova
22 - Nova

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 🙂

sdesabhatla
6 - Meteoroid

Perfect, Thank you!! it resolved the issue.

Labels