How to dynamic output to multiple excel tabs based on a single column values?

wee

Hi all,

Apologies if this has been asked before as I could not find the correct answer or an example to this.

Could you advise (with example if possible), how could I dynamically output into multiple tabs in 1 excel file?

Example of Input:

ID| Name | Customer_Type

1 | MAX | VIP

2 | John | B2B

3 | Mark | VIP

4 | Sue | VIP

5 | Jane | LostContact

6 | Cindy | VVIP

Example of Output file (excel):

Sheet Name:

VIP

B2B

LostContact

VVIP

ID| Name | Customer_Type

1 | MAX | VIP

3 | Mark | VIP

4 | Sue | VIP

ID| Name | Customer_Type

2 | John | B2B

ID| Name | Customer_Type

5 | Jane | LostContact

ID| Name | Customer_Type

6 | Cindy | VVIP

Right now, I have like 20++ customer types and I used the block until done and filter tools to "hardcode" the result.

However, I am expecting new customer type coming in. Therefore, is there a more efficient way to dynamically do this?

Thanks in advance.

Output

Dynamic Processing

Accepted answers

jasperlch

Hi, you can configure that inside the Output tool:

vishwa_0308

Using formula tool right above your output tool you can do this..you just need to pass that field name in your output path.

"C:\Users\Administrator\Desktop\aaa.xls|||"+[FieldName]

and then in output config change the entire path by selecting the field you have created in formula tool.

Thanks,

Vishwa

MarqueeCrew

Configure your 1 output tool like this:

The key is at the bottom of the configuration....

Cheers,

Mark

All comments

jasperlch

Hi, you can configure that inside the Output tool:

vishwa_0308

Using formula tool right above your output tool you can do this..you just need to pass that field name in your output path.

"C:\Users\Administrator\Desktop\aaa.xls|||"+[FieldName]

and then in output config change the entire path by selecting the field you have created in formula tool.

Thanks,

Vishwa

MarqueeCrew

Configure your 1 output tool like this:

The key is at the bottom of the configuration....

Cheers,

Mark

Srinsri

Hi,

Sorry to reopen an old thread. I have a similar issue but the number of possible outputs I have is massive. Will take forever to build that many filters and output files. The catch is, I don't get that many possible outputs on a daily basis.

Example- possible field names that I want to convert into separate output sheets might be around 100. But on a daily basis I only get around 5 of these but cant know which ones. So how do I build it to output to separate sheets based on just the string in one field.

Field 1	Field 2
A	Apple
B	Apple
C	Cat
D	Dog

Need separate output sheets for Apple, Cat and Dog. Please note I will have 100 such possibilities.

Regards,

Shen

[Edited]

Gina2021

Thank you!!!!! This is awesome!

jkell

I have the same basic question as before, but wondering if instead of the output to multiple tabs overwriting the entire tab, if the tool can be configured to overwrite only specific ranges with in each tab (the same range for each tab).

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703