Reporting - Join One to Many Records

[JTHillin]

I have a set of records that I've been joining by record position (since there should only be one record per person); however, I want to join a separate (one) table to all individual records (many). This results in only the first record having the 2nd table:

(1st record)

(2nd-Nth record):

Is there a way to make the second table included in ALL records without having to do some sort of matching prior?

Thanks,

JT

[Luke_C]

Hi @JTHillin 

The append fields tool may be what you're looking for. Could you provide some sample data in excel of the inputs and expected output (not screenshots) so we can play around with a solution?

[danilang]

Hi @JTHillin 

If you join the second table on plan year, you'll have the relevant information from the second table matched up with the corresponding plan year in the first.

If this isn't what your looking for and @Luke_C's answer doesn't match your requirements, can you show us a sample of what the output should be? 

Dan