If the two Excel-files have exactly the same columns they should appear as one single table.
However if there are any type of differences between the number of columns and the names of the columns then they will appear as two or even three tables (due to synthetic key generation).
You can force them to be concatenated though by doing
Afterwards you will see one table and all of the columns - also those that weren't common to both.
If the fields names of both the files are same then auto concatenation will work.
If field names are not same, then rename the fields. If no. of fields are different in both files then use Concatenate keyword between load statement.
You can refer below link for more information:
Thanks for your help - but although it's the same fields it's not working.
to make sure it's the same name - I copied the header line from one file to the other, and now I can load both together, but somehow the "prepare data" that creates all the data attributes doesn't work when loading the second files.
This is the script I'm getting (I can't print screen for some reason):2
LOAD [Call ID],4
FROM [lib://AttachedFiles/call hist.xls]23
(biff, embedded labels, table is Data$);2425
LOAD [Call ID],27
(biff, embedded labels, table is Data$);4750
RENAME TABLE [Data$_af431949-b433-d50f-5ae9-6daead56] TO [Data$];51
RENAME TABLE [Data$] TO [Data$-Data$-1];525