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

[amsrivastav]

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 

I want to stack data of all three sheets into one output; I DO NOT WANT to use MACROS in Alteryx Flow.

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

Please suggest!!

Thanks

Amit 

[amsrivastav]

Hi @aatalai 

No, number of sheets are not fix, it can be of any number.

For Range, maximum range I have observed is from A to BA in excel, to be precise data was available from A1 to BA99999, but again, it may increase further as well.

Regards

Amit

[aatalai]

@amsrivastav thanks for coming back; sorry for being unclear but meant is there a range in the number of sheets you will need importing?

[amsrivastav]

Hi @aatalai ,

No, there is no Range as such, 

Thanks

Amit

[danilang]

Hi @amsrivastav 

There's is no specific rule that says that workflows that use macros can not run on the server.  You may be having an issue with a specific workflow, but in general, workflows that access macros work fine on Server.

What specific macro issues are you facing when try to run your workflow on the server?

Dan

[aatalai]

can creating an app help as per this post? https://community.alteryx.com/t5/Alteryx-Server-Discussions/Analytics-App-Input-is-Excel-file-with-m...

[aatalai]

alternatively try posting on the server forum, you might get more relevant responses

[amsrivastav]

Hi @danilang 

May be, I will give another try to run Macros based flow on Alteryx Server.

However, because of the curiosity, I just want to understand and know, is there any to achieve the same without using Macros in the flow.

Thanks

Amit

[amsrivastav]

Hi,

I don't think, User will go with APP option.

Thanks

Amit

[aatalai]

@amsrivastav if you are going for the macro approach try looking at this post https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Batch-Macros-Excel-data-with-d...