Problem combining two tables

[TotallySmall]

Hello all,

I'm trying to combine two tables containing lab results. 

Both test have the same ID number, and the same amount of results (in this case 20 but I've got other cases which have more and/or less, the data I'm combining ALWAYS have the same amount of sublines tho). 

When I try to fuse the two together, instead of just putting the results next to each other, it is crosscombining all the results (testresult 1 with all 20 results of test 2, testresult 2 with all 20 results of test 2 etc).

I've added a small excel file, sheet 1/2 are the tables I'm trying to combine, sheet 3 is the result I'm getting and sheet 4 is the result I want 🙂

Thanks for reading 🙂

[Qlik1_User1]

In script try like this

Temp_table:

LOAD * from table1;

CONCATENATE

LOAD * from table2;

NOCONCATENATE

FINAL_table:

LOAD *,ROWNO() Resident Temp_table;

DROP TABLE Temp_table;