Stack Overflow
Stack Overflow

Questions tagged [consolidation]

160 questions
1
vote
1 answer

How to do regular database cleanup in a JPA application?

Short background: I have a software that regularly downloads files. The Statistics of these downloads are stored in the database as a DownloadResult entity, which is in turn associated to the entity representing the download job. Now I want to make…
er4z0r
  • 4,711
  • 8
  • 42
  • 62
1
vote
0 answers

Post traverse recursion in VBA to calculate a consolidated status

My apologies as I'm new to VBA. I'm looking for a post-traverse example to resolve the below problem. I'd like to recursively traverse the tree in column A to calculate a consolidated status. As in my example table below "Real Proj 1" has status A…
Christoph Hauser
  • 43
  • 4
0
votes
1 answer

jQuery + Javascript: Consolidate duplicate functions between document.ready and ajax load

I am using the ajaxify.js plugin https://github.com/browserstate/ajaxify to load content dynamically. I have a number of click functions that I bind on document ready, but have to additionally put those functions inside of my ajax load function to…
HandiworkNYC.com
  • 10,914
  • 25
  • 92
  • 154
0
votes
2 answers

How to do arrange data of 2 tables in descending order and then intersect two tables?

Question: Check which subject is among the top 3 scoring subjects for Rahul in Term-1 and Term-2 using mssql? If I use order by before intersect the code is not working. But if I don't sort data of both the tables in descending order individually…
rereer
  • 1
0
votes
0 answers

Is there a way to mimic the behaviour of a Data Dictionary in SQL?

Similar to how data dictionaries can provide a unique key value pair and you can group like keys together and manipulate the value. I need a way to harmonize SQL data rows that exists as unique groups themselves and create new key groups. Current…
Adrien Gagnon
  • 11
  • 2
0
votes
0 answers

VBA - Consolidate different sheets into One without formula and blank row

I have a log file which is recording the staff productivity, each tab sheet is for one staff, e.g. Tom, Oscar, Susan. Each sheet has a Range A:I with identical headers, and some of cells contain a formula which is used to lookup the value when user…
Ivan Wong
  • 1
  • 1
0
votes
1 answer

Consolidate table from vertical to horizontal efficiently

I have a large table with unique characteristics that occur on multiple IDs (table A). Is there a clever workaround in which I could horizontally consolidate the values so that in the second table B I have unique IDs in the rows and in the columns…
freeflight
  • 29
  • 4
0
votes
0 answers

VBA to copy from a lot of excel files to consolidate data into a big sheet

I´m building a sheet to work as a database but I have to collect data from a lot of excel .xls organized in folders like YEAR/MONTH and the file´s name is XXXXX_ddmm.xls for 16 different operation sites (the XXXXX directs to each one). This is from…
Rafael Pisciottano Leitão
  • 1
0
votes
0 answers

Merge rows from multiple tables SQL (incremental)

I'm consolidating the information of 7 SQL databases into one. I've made a SSIS package and used Lookup transformation and I managed to get the result as expected. The problem: 30 million rows. And I want to perform a daily task to add to the…
Luis Tomé
  • 1
0
votes
1 answer

consolidating csv file into one master file

I am facing the following challenges I have approximately 400 files which i have to consolidate into one master file but there is one problem that the files have different headers and when I try to consolidate it put the data into different rows on…
Deva
  • 13
  • 2
0
votes
1 answer

How to sum identical strings and sort them from txt file in python

I have a txt file(named file.txt) that contains two columns(ip-address and bytes, [,,]-separator) file =…
baykos
  • 3
  • 1
0
votes
1 answer

Are splunk forwarders installed on every machine that generates log?

I am trying to understand the splunk architecture and am confused by the articles on the topic. I understand that forwarders retrieve information from the physical log files and forward those to indexers but what I don't understand is how forwarders…
bob dabelina
  • 507
  • 5
  • 20
0
votes
1 answer

How to consolidate data that is being added to every day

I am trying to take data from datafile.xlsx (A1-C7) and consolidate it using the consolidate command into A1 in the same workbook, different sheet Dim iwb As Workbook: Set iwb = Workbooks.Open("datafile.xlsx") Dim insp As Worksheet: Set insp =…
Stefano Di Loreto
  • 3
  • 6
0
votes
0 answers

What is the best practices for consolidating the DB record and send to frontend?

I have a following scenario and would like to seek for advices/recommendation about the best solution to implement it. Assuming I have following data in the…
Khai Zhan YUONG
  • 1
  • 2
0
votes
0 answers

Consolidation of similar characteristics in one column - rename function - industry fixed effects

I am currently doing difference in difference analysis in R and need to incorporate industry fixed effects. Overall, I can categorise my industries by factor(df$Industry) & levels(df$Industry) and then add them to my regression as a factor…
BC31
  • 1
1 2 3
…
10 11