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.
If the data is in the same structure you could use a union tool to collect together the 10 streams and have a field with the relevant table name for each record.
There then is the option at the bottom of the output tool to "Take File/Table Name From Field" you can then use this to create the table name and output dynamically to the require tables.
If they are different structures I think the best way would be to have the separate output tools. It's going to be the most straightforward and also be a visual representation of what is happening so helps on that front too.