How to stack data from multiple worksheet of same excel but different structure

Question

Hi Folks,

I have one excel file (XLSX format) where I have three worksheets say SheetA, SheetB and SheetC.

Columns of SheetA are ColA , ColB and ColC

Columns of SheetB are ColA , ColB

Columns of SheetC is ColA

Note : There can be any number of worksheet and data may have any range of data i.e. any number of columns in a sheet

I want to stack data of all three sheets into one output; I DO NOT WANT to use MACROS in Alteryx Flow.as it won't supported by Alteryx Server (with my vague knowledge)

I tried to use Dynamic Input but it is giving me error stating files having different structure.

Please suggest!!

Thanks

Amit

fmvizcaino · Answer

Hi @amsrivastav ,

The only option besides using macros or adding 3 inputs at once is the dynamic input; unfortunately, it only supports identical structures.

Gladly, you can use macros on your Alteryx Server with no issues and the macro is fairly simple to build. I believe your confusion comes from some macros/connectors being required to be installed on the server as well. However, that doesn`t mean they are not supported. It is only an additional step that your server admin must do for these tools to work properly.

For your macro, you don`t have to install anything on your server. When publishing the workflow in your server, go to the 'Manage workflow assets' and check the macro box. That will package the macro and your workflow and publish both onto the Gallery.

https://knowledge.alteryx.com/index/s/article/Assets-and-Packaging-Workflows-1583460636757

Best,

Fernando Vizcaino