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 having blocker on how to create a multiple excel file (not sheets) output using render tool (i choose render since i need to format my excel file like the fonts and spacing and bold of the header etc.) the outputfile is xlsx. i tried creating a formula with the File Path "<my folder path>\Output\SOA"+ [Account] + DateTimeFormat(DateTimeNow(),"%m %Y") + ".xlsx|||Sheet1". The number of excel file output will depend on the Account. below is the snippet of my wf, basic table and render tool.
I am using the render tool similarly to your example, except that I am going for the 'replace entire path with group' option using the 'Output Location' field.
It works as excepted and multiple files are generated as I want however my problem is that the 'Output Location' field is still remaining in the output excel file as an additional column. Is there a way to get rid of it?