This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
However, in my really task, there might be more than 30 sheets (as output) in this workflow. The output file is an excel workbook contains lots of sheets. I want to add a control element that if a value (something in conclusion) of a sheet is 0, this sheet would not be union into the final output. How can I implement this?
I don't know that I fully understand, but if you have a field (outside your table fields) to determine which sheets are included and which are excluded, you should be able to simply drop a Filter tool after your Union and before your Layout and filter to where [YourField] != 0. If the field that you need to filter on is inside your table fields, you will need to find a way to also include it as a separate column.
Does this answer your questions? If not, can you add more details? Some dummy data would be likely be helpful.
I have tried to append some fields to the end of each sheet for output control. This does work, but cost more processing time than before. If we can control output threat from beginning (or middle) to reduce resource consumption, that would be great.
Anyway, thank you indeed. I will accept your reply as solution.