join multiple files

Hi all,

Is there a way to join multiple files by just putting the records underderneath each other and do a group or pivot operation? 

The only way I see now is to work with multiple joins, which is a pain. The column name starts to repeat after the first join and this requires a workaround to avoid errors.


If the columns are the same name in each file, then you can use Concatenate. Hope this is what you want. If you have many files, then use Concatenate (Optional In). They are under Data Manipulation/Row/Transform.

thanks! you saved me a lot of time...!