Excel Ouput sometimes unexpectedly creating more than one spreadsheet splitting the data

[Muralisagar]

I am performing some cleansing steps on a excel data and when I output - I am expecting a single spreadsheet but sometimes its being saved into multiple spreadsheets (Say I have 20 rows of data in the output, its being randomly splitted into 3 spread sheets and getting saved without any logical criteria)

it doesn't happen everytime - sometimes an output with 100+ rows getting saved just in a single spreadsheet

Is this a known issue or something wrong with the configuration

please advise

@CharlieS 

@DavidP 

[Qiu · Accepted solution]

@Muralisagar 

Not the person you requested, just want to give a try.

Since you are using "Change entire file path", so you are defining the Workbook name and also the sheet name.

Kindly check if there are more that one unique value for the FileSavePath variable when the issue occurs.

[Muralisagar]

good spot, thank you very much Qiu 🙂

I am creating datetimestamp as a suffix to the file name, it is the seconds difference to apply it for all the rows that's causing multiple outputs. I have managed it with Multi-row formula too and it is working fine. thank you again

[Qiu]

@Muralisagar 

Glad to help and thank you for the accept mark😁