Output of Join tool in different sheets

[stataltgee]

I'm trying to get output from L,J,R anchors in different sheets in the same file. I need sheet names as say "one","centre","two". 

I tried creating a column "Sheet" using formula tool for each anchor and then using output tool (take file/table name from field) but its creating 6 sheets that is duplicate of the three sheets. Please suggest a solution.

[OTrieger]

@stataltgee 

Excel cannot have sheets that having the same names, therefore you should check in your WF where additional 3 sheets are been created it has to be in the path as the sheet name will change.

Now was you did not attached any snippet to your post there might be several reasons why it is happening, so any suggestion will be a guess or an assumption.

This is a very basic rule from Lean Six Sigma, you always do Root Cause Analysis for any given problem based on the facts/data. In other words help us to help you by providing data, as you question is not supported by what you did. We can assume why you are facing that issue, but that would be only an assumption and might not bring to the needed resolution.

[Raj]

@stataltgee 
find the workflow attached for reference 
mark done if solved.