create a new workbook whichi contains data from different

[cjain]

i have two workbook... i want to merge them in one workbook but in different sheet.

i don't want to merge the sheets.

[chinu267]

If you can provide sample templates that will be a great help to understand your needs

[cjain]

WORKBOOK1 - SHEET1

WORKBOOK2-SHEET2

MERGE WORKBOOK 1 AND WORK BOOK 2 INTO WORKBOOK 3 WITH 2 SHEETS .

WORKBOOK3 WILL CONTAIN TWO SHEETS 

SHEET 1 & SHEET 2 SEPERATELY

[chinu267]

There are variety of solutions already posted and hope one of them should help:

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Read-in-Multiple-Excel-Files-with-M...

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-to-Input-Multiple-Sheets-from-M...

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-To-Import-Multiple-Excel-Sheets...

[echuong1 · Accepted solution]

You can import both into Alteryx and then use two separate output data tools to write the data out. The tools can be configured for the same output file, but with different sheet names. See attached for an example.

Let me know if this works for you!

[cjain]

Thanks a Lot. I never thought this would be this simple.

Thanks !!