perhaps it is a simple matter but I'm not finding the solution. I have two Excel files with the same columns. I'm trying to load both files with "concatenate" in order to get one only table with records of both files, but instead I get the two tables separately and a third one with synthetic key that includes all fields.
Thank you Frédéric, but it still creates that third synthetic key table. Maybe I have a concept error about attaching Excels in the connection section and the load script. I'm going to review my work and I will write any news here.
Hello, I finally have found the error on my script. I didn't see the "automatic generated section" when importing Excels. That section was importing the information, and I was importing the information again with a new load script in the main section.