Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Ingesting multiple data tables from Excel

Alt_eryx22
7 - Meteor

Hello all, bit of a doozy for you, so thank you in advance...

 

I have some Excel files I'm trying to ingest from, each sheet of each workbook has 1-5 tables stacked. I'm trying to ingest the data and stack it into one data table to get it to look like the "example output" file. I'm attaching a package file that brings in each sheet of the excel files

 

For sheets with one table, I can pretty well isolate the data I need, but trying to bring down the 4-digit code circled below as a column in the data table has proven challenging. I've also attached an example output that I mocked up in Excel.

 

Screenshot 2024-10-22 131931.png

Example Desired Output:

Screenshot 2024-10-22 132217.png

2 REPLIES 2
binuacs
21 - Polaris

@Alt_eryx22 updated workflow attached, it is not a complete solution but it should work for your use-case

image.png

Hsandness
8 - Asteroid

Based off the example output I believe this workflow will return your expected result. 

Labels
Top Solution Authors