Summing tables across multiple tabs

[peterg97]

Hello All, 

I am trying to sum a table across multiple tabs. I have attached an example dataset below. The table below is present in every tab:

I want to sum this table for all the tabs where the tab name includes the word 'Overtime'. I know that I need to input the file as a list of names and then filter for the word 'Overtime' and then use a formula to get the file paths, but I don't know where to go from there. Is there a function that can do this easily? 

Any help is greatly appreciated!

Cheers, 

Peter

[messi007]

@peterg97,

Please see below:

Attached the workflow,

Hope this helps,

[peterg97]

Hi @messi007, 

Thanks for the reply! Unfortunately, this is using a newer version of alteryx so I cant open the workflow. Do you know a way I could open it? Or could you attach some pictures of the inner workings if that's not too much effort? 

Thanks for the help, really appreciate it!

Cheers, 

Peter

[afv2688 · Accepted solution]

Hello @peterg97 ,

I transformed it to you to 2019.1 version.

Hope is good now for you 🙂

If you need to change it further just open it with notepad++. On the first lines you will see the current version of the workflow. Change it manually to one that suits your needs and done.

You need to do this to both, the workflow and the macro.

Regards

[messi007 · Accepted solution]

@peterg97,

that's how you do the downgrade

1- Open the yxmd with note pad

2 update the version

==> have done the downgrade for you to 2020.1you have to open workflow (SUM.yxmd)

be sure to save both .yxmd and .yxmc macro  under the same folder.

Regards,

[peterg97]

@messi007 

Thanks for this, works perfectly! Really appreciate the help!

Cheers, 

Peter. 

[peterg97]

@afv2688 

Thanks for this, really appreciate it!

Cheers, 

Peter