Need help connecting two tables

[regowins]

Hi,

I need help connecting two tables that have similar data. Please see attached example for more details

Thanks for your help!!

[Gysbert_Wassenaar]

Rename Target_name to Target or rename Target to Target_name. Fields with the same name are used to connect tables.

[regowins]

I agree it would work if Target had only a single value in it. How will it work since target has more than a single value. I need to account for the values that have more than just one value. For example, If I clicked on Event -  internal I should see a count of 7 for 'P' target. Thanks!

[rwunderlich · Accepted solution]

As Gysbert suggested, rename one of the fields so the tables link.

Also use the subfield() function to generate a row for each Target value in Excel_Main:

trim(SubField(Target, ';')) as Target

-Rob

[regowins]

Thanks Rob! the subfield() function was helpful. I think I can get what I want from there.