i have two workbook... i want to merge them in one workbook but in different sheet.
i don't want to merge the sheets.
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!
If you can provide sample templates that will be a great help to understand your needs
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
Thanks a Lot. I never thought this would be this simple.
Thanks !!
