Multi-tab output

krbarnes

I am having difficultly with a recconciliation report.  It is a simple reconciliation between 2 files.  What I would like to get to is a single output file with 2 tabs from the join. One with the records in File A that were not in File B, and one with the records in File B that were not in File A. However when running the workflow I can only get one to output, and the other gives an error that the file is in use by another process. I'm sure this is a simple step I am missing, I just can't figure out what that is.

DataNath

Hey @krbarnes, you could do something along these lines:

• Use a Formula tool to on each of the two Join output streams to add a ‘Sheet1’ and ‘Sheet2’ label respectively.

• Union the two data streams

• Use an Output Data tool, choose a location to save to & filename then in the bottom configuration, select to take table/file name from a field > replace file/table name and select your sheet name field that you created in the Formula tools