Macro Input

[micky01]

Hi All,

I'm new to Alteryx Community but have few questions regarding Macros.

I have two excel files for two months August and September and I want to read these two file dynamically but note that the schema for the month of September is  different from August.

August/ September - File 1  -  Contains Only   sheet1 the data for this sheet starts at line 3.

August/ September -  File  2 -  Contains 4 sheets and for this the data  starts at line 1 for all the sheets.

I tried few links to re create a macro but struggling any help would be much appreciated.

[messi007]

@micky01,

Please check this link is good post to do that: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/t...

You find as well the macro that you can adapt to your case.

Regards,

[micky01]

Thank you so much.