I receive files that have a similar structure to the example table below. What I need is a resulting 'total' column that tells me the sum of everything from start to the End including the values in those columns as well. So, I would want to see 2,750 as the result
<tbody>
</tbody>
I may receive the next file with a structure similar to the below table:
<tbody>
</tbody>
For this file, I'd want to end up with a 'total' and see the result of 4,050
The data will always be numbers, but the column headers will vary widely, both in number of columns between start/end and their descriptions/labels.
This is all easy enough to accomplish in the individual files themselves, but it seems like this might save some time. (and seems to be an interesting challenge)
I'd love to be able to set up a query, save a new file to a folder location, refresh query, and end up seeing something like:
<tbody>
</tbody>
Does this seem possible?
Start | A | B | C | End |
1000 | 250 | 250 | 250 | 1000 |
<tbody>
</tbody>
I may receive the next file with a structure similar to the below table:
Start | Duck | Computer | Stick | Paper | F | H | End |
1000 | 250 | 250 | 200 | 100 | 750 | 1000 | 500 |
<tbody>
</tbody>
For this file, I'd want to end up with a 'total' and see the result of 4,050
The data will always be numbers, but the column headers will vary widely, both in number of columns between start/end and their descriptions/labels.
This is all easy enough to accomplish in the individual files themselves, but it seems like this might save some time. (and seems to be an interesting challenge)
I'd love to be able to set up a query, save a new file to a folder location, refresh query, and end up seeing something like:
File Date | Answer |
02/03/2017 | 2,750 |
02/17/2017 | 4,050 |
<tbody>
</tbody>
Does this seem possible?