Hi,
at the end of a process the client wants me to cluster results. No problem, I can filter the results easily, but is it possible to write the results to different sheets of the same excel file at about the same time or is this calling for trouble?
Thanks, best
Jochen
shouldn’t be a problem, but have a look to Default Excel sheet name you might be able to use multiple file output and all the filters are not necessary, but for sure you need to create a column with the output filename and sheet name. But if you design the riles for naming claver you are more flexible incase new elements come up and you don’t need to create additional filters, etc.
You can write to different sheets of the same Excel file. But you need to be careful to set the Output Write mode to Overwrite Sheet (not Overwrite File).
See also:
It may also be worth look into using Output to = Multiple files, so that you can have a single output item, which is a lot more flexible.
https://www.easydatatransform.com/help/latest/windows/html/split_a_dataset_into_multiple_files.html
Hi,
I know about the write mode, thanks for the hint about the output to multiple files, though.
But as I want to write to 12 sheets of the same excel file, the question is more if the quasi parallel access to the excel file is ok or might be a problem.
Easy Data Transform will write to the sheets, one after the other, in a deterministic order.
So it shouldn’t be an issue.
