Consolidation (sum) of several excel sheets with same schema

cycyg

Hello Alteryx Community!!

I have 30 sheets with same schema on excel (schema is as the picture below) and I want to create a new sheet that is the sum of all sheets (same schema also). I tried searching on community for a similar topic but could not find one. Would really appreciate it if somebody can help out with this!

mceleavey

Hi @cycyg ,

I've attached a sample workflow and a couple of tools to do this.

The first tool read in the sheet names and the second loads in all data from all selected sheets and workbooks.

You can then simply create a sum of what you want and output to a single sheet, or group it by filenames and output the aggregations per sheet.

To do that you simply create a formula - <fulpath><filename+"|||<Sheet Name> then configure your output tool accordingly.

Hope this helps,

M.

Multi Sheet Import Example.yxmd

Dynamic Multi File Sheet Names.yxmc

Import Multiple Schema Flat Files.yxmc