Importi ng Multiple CSV/Excel files.

Hi Swam80 

You said you had 5 files - you have many more than that?

The folder connector is designed to load multiple files of the same structure - that is they have the same tables in the that you want to append together.

If you have lots of files with different tables in them, so you don't plan to join them all together, then the folder connector isn't the tool you need.

If you do use the Folder connector, you can click on the Transform button during import (as opposed to Combine and Transform) and you'll get a list of files in that folder.  The first column will be the binarty content of the files.

From this point you have to decide what you want to do.  What is the purpose of loading all these files?

If you have different internal structures in the files, then any query/steps you write are particular to that file(s) structure and won't work for anything else.

Phil