Counting across files

[j_alt_p]

Dear community,

as I am new to Alteryx, I need your help with the following task: I have two files, one with a list of IDs and one with references to those IDs. Now I want to count the number of occurences of each ID of the first file in the second file. Here is an example:

First file (for which I want to compute the second and third column now):

ID	No of occurences citing	No of occurences cited
asd123	1	1
fgh456	2	0
qwe123	0	2

Second file:

No	ID citing	ID cited
1	asd123	qwe123
2	fgh456	qwe123
3	fgh456	asd123

Can anyone help with a simple solution?

Thanks!

[DiegoParker · Accepted solution]

Hi @j_alt_p 

Please find my approach attached:

In this case though you only need your second datasource to reach the output but I joined both sources anyways.

Hope this helps If does, can I ask you to mark it as a solution? this will help other users to find it and will allow us to close the thread. Many thanks!

Best,
Diego

[afv2688 · Accepted solution]

Hello @j_alt_p ,

Is this ok for you:

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

[j_alt_p]

Thanks, works perfectly!