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

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

Output

Accepted answers

Qiu

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

All comments

Qiu

@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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703