YOU ARE WRITING CONCATENATE (YOURFIRSTTABLE)
IT CAN BE POSSIBLE THAT YOU CAN CONCATENATE WITH ANOTHER TABLE, YOU MUST PUT THE NAME
IN TH EXAMPLE
TEST.qvw 146.5 K
It may be that you are looking at the values in a tablebox. QV will list only one row for each combination of values, so it may appear you don't have the additional rows.
Check the table rowcount to confirm whether the secind table is loaded. You can also add a primary key and use that in the tablebox to create unique rows. Add this to your script to generate the PK.
rowno() as RecId