Counting across files

Question

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):

IDNo of occurences citingNo of occurences citedasd12311fgh45620qwe12302

Second file:

NoID citingID cited1asd123qwe1232fgh456qwe1233fgh456asd123

Can anyone help with a simple solution?

Thanks!

DiegoParker · Accepted Answer

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 Answer

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