Multiple sheets

[cireost]

Hi - I am trying to create an app where there is one input to my workflow that creates two outputs that I want to be included in a single excel workbook with the following sheet names 1) Building 2) Land.  

I would like it so that all the user has to do is 1) locate the input file and then 2) pick a directory for the output. (The output will be an excel file with sheet names Building and Land). 

If someone could provide a sample workbook, that would be greatly appreciated.

Thanks!

[mmenth · Accepted solution]

Here's a super basic example that could get you started!

[Thableaus]

Hi @cireost

Here is my contribution with a very simple WF, which is appended.

Cheers,

[NehaNevrekar]

Hi, I am not able to understand the reply.

The query that we have is.

We have a base data in which we wish to select top 20 samples based on the value or the nature from the data. Sample data shall be as follows:

Date	Name	Value
12/06/2020	A	1
13/06/2020	B	2
14/06/2020	C	3
15/06/2020	D	4
16/06/2020	E	5
17/06/2020	F	2
18/06/2020	G	3
19/06/2020	H	3
20/06/2020	I	4
21/06/2020	J	56
22/06/2020	K	6
23/06/2020	L	7
24/06/2020	M	77
25/06/2020	N	7
26/06/2020	O	7
27/06/2020	P	8
28/06/2020	Q	8
29/06/2020	A	89
30/06/2020	B	6
01/07/2020	C	7

The data shall be repeated based on the above. We want to sum the values based on names and then give us top 3 samples.

We want the output in a new sheet within the same excel.