Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Getting Years -- Multiple Excel Workbooks

smoskowitz
12 - Quasar

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 

2 REPLIES 2
DanS
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

smoskowitz
12 - Quasar

Thank you for the help. Yes, thank you.

 

Sincerely,

Seth

Labels