Combine multiple files in directory with common column

Question

Hi all,

I have a directory with multiple csv files. Each file has two columns Date and Attributes. For eg: File1.csv has one sheet with two columns Date and Attribute 1, File2.csv has one sheet with two columns Date and Attribute 2, and so on.

I need to merge the data from these files: The output should have multiple columns such as Date, Attribute 1, Attribute 2 ..... etc.

Thanks

vikaschandra1993 · Answer

Thanks Emmanuel! But I am looking for something different. I need to merge the data from multiple csv sheets with common column.

Eg: I have three csv files in a directory each has one sheet with below columns:

File 1: Sheet 1: Columns: Date, Attribute 1

File 2: Sheet 1: Columns: Date, Attribute 2

File 3: Sheet 1: Columns: Date, Attribute 3

...and so on

I need to join all the data with below columns:

Columns: Date, Attribute 1, Attribute 2, Attribute 3, .... and so onn

Emmanuel_G · Answer

@vikaschandra1993

You can use a wildcard in input tool to import all .csv files from a directory.

Find attached an example.

Note that all my files have the same structure and fields and the output anchor is the union of each records of all files in directory.

Please do not hesitate to mark this answer as solution if helped.

Combine.yxzp