Hi All,
I am trying to export my data (see attached) into multiple excel files e.g. File name is 1234588968 and file contents as shown below:
Poster_Frame_ID
1234588968
Any ideas on the the best way to achieve this please? :)
Thanks!
Solucionado! Ir para Solução.
Hi @Gilld
The output data tool allows you to write multiple files
Just select the operation you want, and the field where the name of the desired file is.
I've tried to use the output tool to do this and am getting the attached - it's splitting the data into different sheets in the same file. How would I split into different files instead?
Thanks for your help!
I think you may consider creating a new "FULL_PATH" field, with a formula tool.
In this case I'd use :
Formula for new path:
"C:\<Your Directory>\" + [Field value to use as file name] + ".xlsx|||<Sheet Name>"
Then, in the Output Tool, Use the "Change Entire File Path" option, with the new field you created in the formula.
For what I saw, this is caused by the shared folder you're using.
Please, try to map the share to a drive letter and try again, it should work.
Please let me know...
I believe you're missing a backslash before the file name
It should be: "Z:\Desktop\KATHERINE\" + ...
Also, try to change the Create New Sheet for the Overwrite Sheet (Drop) in the Output Options
Did it worked?
I have found it helpful to use the FileAddPaths() formula function in this kind of situation -- it ensures that all the proper backslashes are there.