Excel Multiple Input, different layout, different file formats

AA007

I want to read in files that are in xls,xlsx, csv and want to make one layout of the file from the various layouts they have. Big problem is trying to read all data together? Is there a way around or should I have to make all of the files in one format and dynamically reel them in?

echuong1

You could standardize the formats and then dynamically bring all three in. While this is an option, it might not be the best as you'd have to standardize everytime you wanted to re-run this analysis.

Instead, you can bring in each file individually with a separate input data tool. From there, you can use the various functions under Preparation to get the data into that standard format. Once you have all three cleaned up, use a Union to stack them together. This why you only have to configure the cleanup once!

Hope this helps!