I’m trying to create a workflow to write to various sheets in an Excel file, based on a user selection of databases to query.
For example, we have 10 database tables that a user might want to query data from. Let’s just call them Info1, Info2, Info3, etc. A user might want Info2, Info4, and Info7 for account 33388. I’d like them to just enter 33388 into a string configuration node, and then check the boxes next to Info2, Info4, and Info7, and it would generate an Excel file with three tabs, named for each of these datasets.
As far as I can tell, I can’t make the number of sheets generated via an Excel writer node dynamic, so here’s how I’ve thought I could do it. I would just create 10 sheet input ports on the Excel Writer, and then I could use variables to specify what query the user wants to select. Then I would need to split my data into multiple output ports. Is it possible to split data into multiple output ports using one node? I think I might just need to make a chain of row splitters, right?
Is this the best way to accomplish what I’m trying to do? Any more elegant suggestions?