How to extract particular columns from different sheets within one excel

[Kate13122]

Hi everybody,

I am facing to issue with getting particular columns from different sheets within one excel file. 

I have a case: a file with 12 sheets. These sheets have information for a particular period (month). I would need to get from each sheet column e.g. "invoice number" "tax amount" and "period" rest of the columns are not necessary to keep for the rest of the flow because I need to have for further calculations just these 3 columns to show. I kindly ask you for the solution how can I get from each sheet this information and merge them into one output  e.g.

invoice number period    tax amount

       2525            Jan 22   5000

       2526           Feb 22    3000

I tried dynamic input but I do not have the same schema and the file is huge with the data. I tried to create a batch macro but it does not help me. 

Maybe resolve this issue with some formula?  but I do not have any idea how to do that. 

Could you please advise? 

Thank you in advance

Katarina 

[AlteryxMatt]

Hi Katarina, 

I would suggest posting a sample workflow so other users can get a better idea of what it is you are trying to accomplish. Also, please specify in the post if data given is real or fake!

[Emmanuel_G · Accepted solution]

@Kate13122 

I built a batch macro to do that.

In order to keep only some fields from each sheet, I used dynamic select within the batch macro to specify the fields I want to keep as shown below.

Previously, each sheet contained 6 fields. And after the dynamic select to keep just 3 fields. I delete all others fields.

And this is the workflow

Find in attachement the package with macro, sample data. Let us know if it works as you want please.

[Kate13122]

@Emmanuel_G Thank you very very much. Resolved :) 

[Emmanuel_G]

Pleasure is mine 😉