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 PIDP_CategoryMarketCurrencyA1EdibleAPACINRB2Non-EdibleUSUSDC3EdibleAPACUSDD4EdibleUSUSDE5EdibleUSUSDF6Non-EdibleAPACUSDG7Non-EdibleEuropeGBPH8Non-EdibleEuropeUSDI9EdibleUSUSDJ10EdibleUSUSD Requirement: Create separate excels for each Product and having data related to that product only 1 file - A.xlsx Data : Product Name PIDP_CategoryMarketCurrencyA1EdibleAPACINR 2nd Files - B.xlsx Data : Product Name PIDP_CategoryMarketCurrencyB2Non-EdibleUSUSD Similarly for rest til J Regards, S

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

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,

Output

Accepted answers

seven

Hi,

sorry, I made a mistake. Do this.

seven

Here is an example

product_excel.yxmd

All comments

seven

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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703