Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Getting Years -- Multiple Excel Workbooks

Highlighted
11 - Bolide

Hey Again --

 

So you have all been awesome in helping get a single year in a dataset. I figured out how to bring in multiple workbook sheets into a single stacked dataset, so now the workflow breaks.

 

So, now I am trying to figure out how to build the workflow with the stacked data so the year is associated with its corresponding data.

 

So 2014 (row 4) data is associated with the data down to the next year (2015 in row 37). The original workflow is attached in Cash Taxes.yxmd and works for a single dataset. I changed the yxzp to have an * so it pulls in all of the workbooks. The sheet is Cash Taxes - WW for all workbooks.

 

I can't wait to get better with this tool.

 

Thanks for your help.

 

Seth 

Highlighted
9 - Comet

Hey Seth, 

 

Glad you got it working. If you want to associate the file. Setup your input like the below:

 

File_Name_Save.jpg

 

From there it should append to your data at the end column. 

 

I think this is what you were looking for. Hope that helps!

 

Thanks,

Dan

Highlighted
11 - Bolide

Thank you for the help. Yes, thank you.

 

Sincerely,

Seth

Labels