This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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:
Any ideas on the the best way to achieve this please? :)
Go to Solution.
Go to Solution.
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.
I've used the formula you suggested and am getting the attached results - there seems to be an error something, not quite sure where though!
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've changed the file path but am still getting an error somewhere (see attached) ?
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.