I need to load two tables, stored in two Excel files. The two files has the same structure, with the same column names, but I need that each file be loaded in a diferent table. If I try to load the files, QW store the two files y the same table.
How can I do that without changing the columns name?
use the NOCONCATENATE statement between the load of the two tables. You will get a synthetic key table however because of the corresponding column names. You could use the qualify statement to set a different entity name before the column names.