Is there any way of overwriting the EDT default name when outputting to multiple files? I know you can put it in square brackets for a single file, but I can’t see how to do it for multiple files.
Thanks
you need to add the sheet names to the file names for the multiple output.
Multi Excel sheet output.transform (2.2 KB)
If the sheet names are based on some rules you can write them into an own filed which is enriched with the brackets for the sheet names and concat these with the file names and remove all intermediate columns before export.
3 Likes
That’s exactly what I was after, thank you