Read in Excel with several Tabs

Question

I have a monthly reporting excel data file - It has 2 tabs - I only process data on the 1st tab - however, I want it to read in & output the 2nd tab with no calcs done to it.

So tab 1 has data that my flow manipulates - preps for new month - but the 2nd tab must be just a flow thru so it is saved in the output in the same schema it came in on.

Will also search but wanted to hear everyone's thoughts

Thx - TDK

marcusblackhill · Accepted Answer

Hey @tkozlyk !

You can put one input tool to the 1st tab, do all your changes and point to a file in output tool, like create new file and put another input tool to take that 2nd tab and link directly with a output tool to the same file you pointed the first but with the config create new sheet.

If you get error doing that, try to put the Block Until Done tool between the 2nd input and output.

Hope that help!