Pull out multiple sheets from one input tool

[itstushar]

I was working on the file and there are multiple sheets need to be pulled from one excel file. I was not sure how we can give one source of information and pull multiple sheet from one source as per the requirement. So wanted to submit this idea to create a toll which can pull any sheet(s) from one input tool as per requirement.

[simonaubert_bd]

Hello @itstushar 

I think this is similiar to this idea :
https://community.alteryx.com/t5/Alteryx-Designer-Ideas/Output-distinguish-between-Append-Prefix-Suf...

Best regards,

Simon

[itstushar]

Hello @simonaubert_bd,

I think the idea you mentioned is bit different, as my issue was if I need to use the data available in multiple sheets of one excel file, I don't want to use Multiple Input tool to select each tabs manually. There should be an easy option to give one Input tool and extract any(s) sheet from that excel as per the requirement.

I did this but there was multiple tools required to be able to achieve this.

Best Regards,

Tushar