How to get one output workbook file with different tabs

Hello ,

If there is different input file and want all file into one workbook with different tab, how to achieve the result.

E.g. - Input- File 1, Input- File 2, Input- File 3 -- Output file - workbook file with different sheets in it -File 1, File 2 & File 3.

Common Use Cases

Accepted answers

fmvizcaino

Hi @Rajeev18 ,

Attached is an example showing how to get this done.

Let me know if that works for you.

Best,

Fernando Vizcaino

2019-11-26 How to get one output workbook file with different tabs.yxmd

All comments

Jonathan-Sherman

Hi @Rajeev18,

You'd need to union all input files together, create the name of the tab with a formula tool and in the output tool select the checkbox "take file / table name from field". I'll put together an example for you.

If this solves your issue please mark the answer as correct, if not let me know!

Regards,

Jonathan

DanielMS

Hi @Rajeev18,

I have attached a workflow that has 3 inputs going to 1 output with 3 sheets in.

Hope this helps.

Dan

Multiple Files to multiple sheets.yxzp

Jonathan-Sherman

Hi @Rajeev18,

The example @DanielMS has posted is perfect, the main points to take into consideration is:

On the input ensure (5) Output file name as field uses "file name only"

Ensure the yellow areas have been amended

If this solves your issue please mark the answer as correct, if not let me know!

Regards,

Jonathan

Rajeev18

Hello @DanielMS ,

Could you please share the example in lower version, as am not able to open in my version.
My Installed version -Alteryx Designer 2018.4 x64

Regards,

Rajeev Jaiswal

Rajeev18

Hello @Jonathan-Sherman ,

Thank you for taking time and replying the query. Unfortunately it did not give the result which i was looking for.

Example - Input ___ File -A , File -B & File -C

Output File requires data from the File A,B & C under different sheet - one Output Workbook sheet named - File 1, File 2 & File 3.

Regards,

Rajeev Jaiswal

fmvizcaino

Hi @Rajeev18 ,

Attached is an example showing how to get this done.

Let me know if that works for you.

Best,

Fernando Vizcaino

2019-11-26 How to get one output workbook file with different tabs.yxmd

Rajeev18

Hello @fmvizcaino

Could you please help me with one more query.

I need output file with multiple sheets and color formatted data based on certain condition.

Input file 1(Raw Data): From this file I want output file (sheet named as submitted ) with data which should includes data of 1st level Approval status of submitted one and 2nd level Approval status of submitted and completed . Means submitted output file should not include any data of rejected, WIP, In issue, Not Sent.

Similarly From same Input File 1(Raw Data) :- one more output file (sheet names as Accepted) with data which should includes data of 1st level Approval status of Accepted and completed one and 2nd level Approval status of Accepted and completed.

Product ID	Product Name	1st level Approval status	2nd level Approval status
12345	X	Submitted	Submitted
23456	Y	Submitted	Completed
98766	Z	Accepted	Not sent
45678	A	Completed	Accepted
32156	B	Rejected	No Demand
23457	C	WIP	Not sent
45678	W	Submitted	In Issue
12980	X	Accepted	Accepted
45987	Y	Not sent	Submitted
345678	Z	Accepted	Accepted
234568	Q	Submitted	Submitted
245677	P	In Issue	WIP

Output file 1 ( Sheet named Submitted ) will looks like this:

Product ID	Product Name	1st level Approval status	2nd level Approval status
12345	X	Submitted	Submitted
23456	Y	Submitted	Completed
45987	Y	Not Required	Submitted
234568	Q	Submitted	Submitted

Output file 2 ( Sheet named Accepted ) will looks like this:

Product ID	Product Name	1st level Approval status	2nd level Approval status
98766	Z	Accepted	Not sent
45678	A	Completed	Accepted
12980	X	Accepted	Accepted
345678	Z	Accepted	Accepted

Input File 2(New York): - This Input File should come exactly in same format in same output file named as New York with combination of few color formatting .
Like for status - "In transmit ' - Yellow Colour, "Accepted" - Green Colour, "Rejected", "In Issue" and "May get Rejected" - Red Color in both the approval Column.

Product ID	Product Name	1st level Approval status	Date	2nd level Approval status	Date
12345	M	In Transmit	12/13/19	Submitted	12/13/19
23456	N	In Transmit	10/19/19	Submitted	10/19/19
98766	Z	Accepted	12/13/19	Not sent	12/13/19
45678	A	Accepted	11/25/19	Accepted	11/25/19
32156	B	Rejected	12/13/19	Rejected	12/13/19
23457	C	WIP	10/29/19	In Transmit	10/29/19
45678	W	Submitted	12/11/19	In Transmit	12/11/19
12980	X	Accepted	12/11/19	Accepted	12/11/19
45987	Y	Rejected	12/01/19	Submitted	12/01/19
345678	Z	May get Rejected	12/11/19	Accepted	12/11/19
234568	Q	In Issue	10/27/19	Submitted	10/27/19
98765	s	Accepted	12/13/19	In Transmit	12/13/19

Output File (New York) - should have this color combination: in same excel workbook under sheet named- New York

Similarly for Input file 3 ( California) & Input File 4 ( San Francisco) - Output file should have same colour combination ( as was done for New York) in the same workbook under sheet name - California & San Francisco .

In addition to that out of the Rejected one from New York , California & San Francisco data , latest rejected data (latest should count should based on current date and Current minus 1 day) i.e. for Today's date (12/13/19) Reject for 12/13/2019 and 12/12/2019 should come into one another sheet name -Rejected status in the same workbook.

Another requirement is that "In Transmit" product status from New York , California & San Francisco data should eliminated from submitted sheet(i.e.which was already extracted as output data sheet name - Submitted). Means submitted sheet should not contain "In transmit" producdata .

Hope I am able to make you understand what exactly I am looking for, I have attached all the file for reference .

Thank you in advance!

Regards,
Rajeev

Input File 3(California).xlsx

Input File 2(New York ).xlsx

Input File 1(Raw data).xlsx

Ouput file.xlsx

Input File 4(San Francisco).xlsx

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703