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 · Accepted solution]

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.

[kumaranvr1984]

Hi,

You can try this simple excel logic or try to fetch this formula thru alteryx. I have attached the sample excel for your reference. Hope this helps.