Getting Years -- Multiple Excel Workbooks

[smoskowitz]

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 

[DanS · Accepted solution]

Hey Seth, 

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

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]

Thank you for the help. Yes, thank you.

Sincerely,

Seth