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.

[Qiu]

@praneshsapmm 
Bacically same with @mceleavey  But provide a sample workflow

[praneshsapmm]

@Qiu 

Do you mind to covert the workflow to .yxmd format . 

One you sent is not compatible to me . 

Thanks.

[praneshsapmm]

@Qiu 

No problem . I managed to open. 

Thanks one again .

[praneshsapmm]

@Qiu 

Just a small difference i have noticed , iam trying to upload all the files through directory and all the files have only one worksheet. 

[Qiu]

@praneshsapmm 
I think that is the limitation of directory tools.

I found some reference workflow here and maybe you can find some one useful.
Appeciate if you would mark it as accepted if it works for you.

[praneshsapmm]

@Qiu 

Thanks for sharing .

But i have no clue how these tools works 🙂 .

I will try to understand . May take some time .

Thanks.