Creating Dynamic excel output tabs

[aishwarya_baburaj98]

If below is one of my input column for this month, I want to dynamically create an excel output- with tabs with named A, B and C&D.

A

B

C

D

But, in next the month, my input column, is only below. So, I only want tabs for A,B&C.

A

B

C

How do I dynamically create tabs each month? Tabs can increase or decrease depending on my input that varies every month. 

[atcodedog05]

Hi @aishwarya_baburaj98 

Assuming you are creating new file each time and not overwriting. Here is how you can do it. You can configure output tool to change sheet name based on column.

Workflow:

Hope this helps : )

[binay2448]

If I understand correctly, below is my solution

[atcodedog05]

Hi @binay2448 

You might want to check your output once when you configure it to overwrite file it overwrites the whole file between each sheet write this way at the end you will have only the last sheet (D).

Hope this helps : )

[binay2448 · Accepted solution]

Hi @atcodedog05 ,

You are correct, I missed that

find attached updated one

[atcodedog05]

Not sure how it happened. Seems like i have attached a wrong screenshot 😅

[aishwarya_baburaj98]

Sorry for the late reply. And, Thank you for all responses.

If I understand correctly, this solution only works in a scenario where you are creating new excel sheet. This would not work if I want to overwrite over the existing sheet and delete the unnecessary tab. 

The current solution is perfect for meeting my current needs. But, I just want to understand to what extend I can tweak this workflow for any other scenario. 

[atcodedog05 · Accepted solution]

Hi @aishwarya_baburaj98 

There is no way to make it work if the file needs to be overwitten. The only way we can getting working is if we create new files.