How to create different excel files from one column in a table?

[sakshim]

Hi,

I need help in creating different Excel files for each product from each row. I have a table having unique information about 10 products in a table. Now I want to create 10 different files for each product having name as "Product Name"  & 1 row in each file. For Instance,

below is my table :

Product Name	PID	P_Category	Market	Currency
A	1	Edible	APAC	INR
B	2	Non-Edible	US	USD
C	3	Edible	APAC	USD
D	4	Edible	US	USD
E	5	Edible	US	USD
F	6	Non-Edible	APAC	USD
G	7	Non-Edible	Europe	GBP
H	8	Non-Edible	Europe	USD
I	9	Edible	US	USD
J	10	Edible	US	USD

Requirement: Create separate excels for each Product and having data related to that product only

1 file - A.xlsx

Data : 

Product Name	PID	P_Category	Market	Currency
A	1	Edible	APAC	INR

2nd Files - B.xlsx

Data :

Product Name	PID	P_Category	Market	Currency
B	2	Non-Edible	US	USD

Similarly for rest til J

Regards,

S

[seven]

Hi

add a formula tool and construct a field, for example output_name. This field has the path of the output files concatenated with the Product Name field you have.

Next, connect an Output tool and set the options at the bottom to change the entire file path and take it from the output_name field you just made. Then you're done!

[sakshim]

Hi, It is giving me an error , Stating you must specify sheet name .Also, If I have let say 4 lines for Product A and 10 lines for product B then will this club all lines pertaining to said product will come in 1 file ? or there will be seperate file for each row

?

I want to have only 10 files pertaining to each product irrespective of the number of rows associated to specific product.

thanks

[seven · Accepted solution]

Hi,

sorry, I made a mistake. Do this.

[seven · Accepted solution]

Here is an example

[sakshim]

this is really great..... actually helped to save a lot of time...

Appreciate your help.

THANK You