Creating multiple files in different excel files

praneshsapmm

Dear Community , 

I need some support on below requirement : 

Iam uploading different excel files A ,B ,C ,D . 

The output is generating as mentioned below : 

Worksheet = WS

Output In single excel file .  : AWS1+AWS2+AWS3+BWS1+BWS2+BWS3+CWS1+CWS2+CWS3+DWS1+DWS2+DWS3

Is there a way of doing as mentioned below : 

Excel1 : AWS1+AWS2+AWS3

Excel2 : BWS1+BWS2+BWS3

Excel3 : CWS1+CWS2+CWS3

Excel4 : DWS1+DWS2+DWS3

Thanks.

mceleavey

Hi @praneshsapmm ,

Yes, you need to build a formula that creates the full path for the output such as:

"C:\Users\name\Folder\<Filename>"+"|||WS1". You can then make the elements of the full path dynamic according to whatever logic you have that separates the records into different worksheets.

Once you've done this, on the output tool configure the full name of the output file to be taken from a field:

This will then output each record to a specific file and sheet.

Hope this helps.

M.