inner joint on 1

Question

Hi,

is there a way to joint 2 sets of data (Table 1 & Table 2) base on record sets from Path column in table 1? see below:

results table below only showing 2 path I couldn't paste the entire results its too much. Thanks.

Table 1  Table 2   PathLine Step 1Step 2Step 3Size1Top DeparturesLosses 3372Top DeparturesTemp Leave 953Top DeparturesTransfers to Sub Unit 5514Top     1Bottom     2Bottom     3Bottom     4Bottom            Result      PathLineStep 1Step 2Step 3Size 1TopDeparturesLosses 337 1TopDeparturesTemp Leave95 1TopDeparturesTransfers to Sub Unit551 2TopDeparturesLosses 337 2TopDeparturesTemp Leave95 2TopDeparturesTransfers to Sub Unit551

CharlieS · Accepted Answer

Hi @BosKev

I think what you're looking for is the Append tool. Check out the attached example to see the Append tool in action and let me know if you have any questions.