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!
Solved! Go to Solution.
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.