Render tool as output with multiple excel file (multiple file not sheet)

Hello Guys,

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.

Thanks! sample wf.JPG .

basic table.JPG

Reporting

Accepted answers

grazitti_sapna

Hi @KEPM23 , there is a simple way out for this to work if that is what you are looking for?

1) In formula tool just specify the format of output file you would like as if in your case it is ID+CurrentDateTime.

2) Set the output path where you want the files to be written and then simply prepend the path column mentioned in the above step.

Also,sharing my workflow for better understanding.

test.yxzp

grazitti_sapna

Welcome @KEPM23 , please mark the post as a solution, to help others for future references.

Thanks!

All comments

grazitti_sapna

Hi @KEPM23 , there is a simple way out for this to work if that is what you are looking for?

1) In formula tool just specify the format of output file you would like as if in your case it is ID+CurrentDateTime.

2) Set the output path where you want the files to be written and then simply prepend the path column mentioned in the above step.

Also,sharing my workflow for better understanding.

test.yxzp

KEPM23

Thanks @grazitti_sapna ! It works!

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335