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.
That's fine, if you look at the example I show above for the Output data tool, you pick the option "Take file/Table name from field" and also "Change entire filepath". Below it you can then pick the field name that contains your file path and filename. In my example the field is filename.
With an Excel file, the field also has to include the sheet name, so your filename field should look something like this:
Hi David, thanks for that could you supply your example workflow please with a directoyas I have made the change but get the error a record was created with no fields, so the original data is lost and the new file is being created but just with the filename and path.
I think it might be relevant to the sheet which is Page1 from the Excel source file.