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

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

Workflow

Output

Help

Accepted answers

gautiergodard

@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!

All comments

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

@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")

" " + DateTimeToday()

Hope this helps!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703