Required sheet wise data from many outputs

[Maheshp]

Hi Team,

We have 5 outputs, but we want all the outputs in one excel sheet " mean tab/sheet wise data " Like sheet 1, sheet 2, sheet 3 we are looking for".

Can you please guide us for that tool, who can give us a result.

Regards,

Mahesh

[gawa]

hi @Maheshp 

As it is not clear for me whether you try to (1)read or (2)write to multiple sheets, I prepared solution for both cases as attached.

(1) When you need to read multiple sheets, Input tool + Dynamic Input tool would help as far as schema is always the same.

(2) When you need to write to multiple sheets, use option "Take File/Table Name from Field".

[Maheshp]

Hi Gawa,

Thanks for your reply, but i am saying, in our one workflow there are three outputs, and we want those three outputs in one excel file on different sheet ( like sheet 1, sheet 2, sheet 3). 

Example attached.

Regards,

Mahesh

[gawa]

@Maheshp OK, that is what I explained as (2) in the above post. Please open the above WF yxzp, and see how it works.