Merge Sheet

Question

Hi Team,

1st Query

Need one solution on excel workbook - I have multiple sheet in one workbook and that need to merge into one workbook.

2nd Query

First sheet has all the sheet name on column A .

All the sheet name on column A has muliple sheets.

from 1st Sheet I need the specific detail from all the other sheets. How to do this form Alteryx?

binu_acs · Answer

@Ganesh123 Updated the workflow based on my understanding. Since you have all the requried sheet names mentioned in the Sheet1 you can use a filter tool and filter out the sheet names which you don't want to be in the output

Dynamic_Input_0928.yxzp

binu_acs · Answer

@Ganesh123 can you elaborate more about the second query?

binu_acs · Answer

@Ganesh123 for your first query you can use the dynamic input tool to get all the sheets in to one workbook. Make sure that all of your sheets are having same schema, i.e the field names and the number of columns are the same. attaching sample workflow reference

Dynamic_Input_0928.yxzp