Stack Overflow
Stack Overflow

Questions tagged [consolidation]

160 questions
0
votes
1 answer

How to consolidate data into tables c# SQL

I have XML data which I read into a dataset via xml reader. The tables generated have several relationships but mostly the parent node to child node. I plan to read multiple files each day and consolidate the files into a sql server. Where they…
Ken
  • 2,518
  • 2
  • 27
  • 35
0
votes
0 answers

Excel 2013: How to consolidate data from multiple sheets into a pivot table

I am trying to consolidate data with the exact same columns, from multiple worksheets (or ranges) into a pivot table. My data is a bunch of savings initiatives that are distributed over a certain amount of areas within the organization (such as HR…
Carl
  • 101
  • 1
  • 11
0
votes
2 answers

Merge and consolidate rows based on date in SQL Server

i have a table with billions of records which is holding Merchandise information as follows. ID is bigint with auto increment. Article, UPC and MRP is actual data. DataDate is having the information like from which date this MRP is applicable. ID …
Vineet Jaiswal
  • 31
  • 1
  • 6
0
votes
0 answers

grep printout, whitespaces consolidated

My own bash script searches compilation logs (higher-level logs generated by Bitbake cooker while cross-building a Linux software package) for compilation command line strings. Those command strings in searched logs are huge in length, more than…
user5494920
0
votes
1 answer

SQL consolidating data best Strategy

I am using SQL Server 2005. I have 8 databases in the same SQL Server. There is a table containing thousand of Customers in each database (Property). To make it simple CustomerID numeric(18,0) PropertyID int CustomerSurname…
PanosPlat
  • 940
  • 1
  • 11
  • 29
0
votes
1 answer

Total Result, (Sum or Subtract some Value) according to Flag Column Oracle SQL Developer

I'm newbie in SQL Developer. I have a query result like the above image. I want to know how to sum all values with Flag = 1 and to subtract all the values With Flag = 2 in order to obtain a total result?
user7339033
0
votes
1 answer

How to consolidate my data for SQL Join Clause

I have to write a query with the following criteria: Write a query to list the title and artist of ONLY the items that have been ordered. Only list each title once. Here are the CREATE tables that were made that cannot be changed. CREATE TABLE…
Eric Franklin
  • 45
  • 4
0
votes
2 answers

product table consolidation process from different data sources

Our company used to have onpremiere and cloud ERP systems and they finally wanted to pull data from each ERP systems to staging database in our datawarehouse. These two systems are identical interm of table strunctures and schemas however,we need…
ahmet ciftcioglu
  • 1
  • 2
0
votes
3 answers

Consolidating integers within Ruby (on rails)

I have a class which contains two integers (a and b) and a reference to an entity. I want to be able to report back on the sum of all the a's and b's within the class. E.g. I might have three records: Entity 1 2 3 a 5 9 3 b …
cmcc333
  • 1
  • 1
0
votes
1 answer

VBA merge workbooks in a folder

I need to merge all workbooks in a folder to one file, specifications i'm looking is my folder is dynamic so i need a folder picker for the code. Next thing each workbook in the folder has multiple sheets, i need to consolidate only the sheets with…
aji
  • 59
  • 3
  • 11
0
votes
1 answer

Consolidate, merge and sum values in vba

I have a table which has duplicates of the same person and I'm wanting to merge these down into a single row whilst summing up two columns assigned to each row of data. For example: I am wanting to merge the data in columns A to D by using column A…
jufg
  • 113
  • 1
  • 10
0
votes
0 answers

Advanced Consolidation in vba

I have created a macro to combine two different sheets and apply various formulas. Now, I want to perform a consolidation. I am rather new at VBA so I dont quite know the capabilities of it. Is it possible to perform a consolidation (to a specific…
Pericles Faliagas
  • 636
  • 9
  • 29
0
votes
1 answer

Consolidate data and provide average of the consolidated data

I am writing a macro, which will be used to consolidate data from a range of cells. I have the table with the data that I want to consolidate in sheets("1") in Range D2:J6 and the destination location is again in sheets("1") in M2:R2 (the colums M…
Pericles Faliagas
  • 636
  • 9
  • 29
0
votes
1 answer

Excel, auto refresh consolidation statistics

What if I have list of activities and every day I fix how many hours were spent reading, writing, etc. And I want to see summary by Date field, for example 17 July I was walking for 4 hours and reading for 7 (total is 11): I added consolidation by…
Gennady G
  • 996
  • 2
  • 11
  • 28
0
votes
0 answers

Survey Monkey- Responses data consolidation

I have created 116 surveys under my account. All the surveys have 50 similar questions with different images presented. I wanted to know if there is a way to export the responses of all the surveys to a single CSV file.
AKSHAYAA VAIDYANATHAN
  • 2,715
  • 7
  • 30
  • 51
1 2 3
…
10 11