Stacking Data from Multiple Excel Files in Alteryx

Akh275

Question: How can I get the values related to each member given the data is piled up sequentially?

I'm currently importing multiple xlsx files from a specified directory. However, the data from these files seems to stack up sequentially. I aim to produce an output where, to the left of column B2 (always labeled "Group"), individual member names are listed, which I intend to filter on. The subsequent values should correspond to each member. But these member names recur in the data (since its stacked), but their order may differ. Regardless of the sequence, they will always be positioned to the left of the "Group" label in column B2.

I'm dealing with over 50 files, and it's impractical to use the input tool to join them individually. Tried using the Dynamic Input tool which was unsuccessful due to occasional header misalignments.

I've attached a sample dataset of what the output in alteryx looks like

test3.xlsx

cjaneczko

Take a look at the following posts. The first one shows a flow chart based on your data and which method to use when inputting multiple sheets.

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/ta-p/20480

This one here, if you can get all the headers aligned properly works as an excellent macro to pull all the sheets in a directory. The last page on the post has the updated macro for the most recent version of Alteryx.

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Input-Batch-Macro-AKA-the-Extra-Dynamic-Dynamic-Input/m-p/1173625#M290609