Creating YTD output file with MTD Input data

[ankush-agrawal]

Hello,

Thanks for stopping by. Appreciate if you can provide solution to below problem:

I have MTD Input file, which I generate from Local source and save at share drive.

I have managed to create required output data but facing issues while exporting it to excel.

I want to create YTD output data which should accumulate each MTD data every month I run it.

Jan> Jan MTD= YTD

Feb> Jan MTD (from previous run) and Feb MTD from current run.

Please note: Every time I run workflow, the input data will be MTD only.

[SoccerTil]

The solution to the basic requirement is simply to Union the two data streams and then summarize the results. If your real problem is more complex then adding additional steps within the basic work flow would be required.