After adding to workflow my render tool now splits into two files

[Travis_Ratliff]

Hello,

As the title states I added onto my workflow and now my render tool that I use at the end of the workflow separates into two files at the point of where I added on to the workflow. I have attached two screenshots below, the first is before addition and the second is after addition. I have also highlighted the two tools where the addition starts and ends. To note/summarize the workflow before addition was all rendering to the same excel spreadsheet and not that I have added this portion that first table is getting its own excel spreadsheet. 

Let me know if there are any questions, I know this is not the greatest explanation.

Thanks in advance

[gautiergodard]

hey @Travis_Ratliff 

The render tool and most reporting tools have group by options, are any of these selected within your workflow?

If you could share the workflow, it would make it easier to diagnose the issue. However, if you cannot, could you please share a screenshot of the inputs that are going into the render tool and the messages Alteryx gives you in the result window once the outputs have been generated? 

[Travis_Ratliff]

@gautiergodard I have attached workflow

[gautiergodard · Accepted solution]

@Travis_Ratliff Thank you! 

I believe the cause of the problem is the FullPath field you are creating. 

" " + DateTimeFormat(DateTimeNow(),"%Y-%m-%d %H-%M")

When doing this you are adding a date and a time stamp in hours and minutes to your file name, so if the workflow takes longer than 1 min to run, you are likely ending up with a FilePath with a slightly different time by time the data flows to your render tool since you are grouping by this field. Try replacing the fullpath formula with:

" " + DateTimeToday()

Hope this helps!