Stack Overflow
Stack Overflow

Questions tagged [consolidation]

160 questions
0
votes
1 answer

How to copy file name to a cell, remove extension but preserve formatting

I have an excel VBA script that I am using to consolidate a bunch of reports (roughly 100) into a single worksheet, for each worksheet that I am adding I would like the file name to appear in a column, however I need to remove the extension ".xlsx"…
talayan
  • 3
  • 2
0
votes
1 answer

Consolidate related taxonomy array settings to be used in a Wordpress query

I'm building a filter system with checkboxes for a custom post type. I think the Wordpress query expects that same types of taxonomies are in the same array. The code below doesn't display any 'merk' (brand). If I just select one brand it works…
user3183258
  • 11
  • 1
0
votes
1 answer

Consolidated Notification email for scheduled builds in TeamCity

Is there a way to consolidate the reports and artifacts generated across several test integration projects that run every night in TeamCity and send out just one email notification that links to all those build run summary/artifacts?
S_M
  • 1
0
votes
1 answer

Using dplyr to merge datasets and consolidate columns R

I have two datasets that I am trying to merge. They are not complete datasets, so this means that individuals are missing records. Here is data1 (example is a subset of my real data): squirrel_id age ageclass trialdate year OFT1 MIS1 …
Blundering Ecologist
  • 1,199
  • 2
  • 14
  • 38
0
votes
1 answer

Consolidation from 2 DataFrames to 1

I've written the code below. It works, but I'm sure I can do clearer and faster. The idea is: I have 2 input DataFrames and I want 1 DataFrame as output. DF1 is like Name, Attribute1, Attribute2, Attribute3, ... DF2 is like Name1, Name2, Value1,…
Zal78
  • 77
  • 1
  • 5
0
votes
1 answer

Consolidate list of dictionaries elements in dictionary

I have below complex structure with dictionaries with a number of repetitive keys. I want to consolidate the below structure and return the below structure. Tried multiple ways but not able to crack it. Please help. Input structure: {'lst_1':…
TR007
  • 47
  • 1
  • 8
0
votes
2 answers

dHow to execute multiple lines of code, Python, Selenium

I am building a stock trading bot for fun and buying/selling on a stock trading simulator. I have all the webscraping done, all the send_keys done. I just want to be able to execute multiple lines of code as one simple command instead of having to…
Kenneth Goodman
  • 37
  • 1
  • 5
0
votes
1 answer

How to copy, transposing and consolidate data from several workbooks to the original active workbook?

I´m new and starting to make baby steps in VBA. I want to make a macro that opens CSV files and that asks for a range to be selected from the first file (I need to select a column vector and that range will be the same along the macro), extracts the…
Hols Muller
  • 1
0
votes
1 answer

Why Netty's CompositeByteBuf consolidates automatically if the number of components in CompositeByteBuf exceeds 'maxNumComponents'

I’m trying to understand why CompositeByteBuf, consolidates if the number of components in the compositebytebuf becomes more than ‘maxNumComponents’ while adding component? This consolidation involves copy operations. My questions are - why…
Charan Reddy
  • 1
0
votes
4 answers

Creating a consolidated set of pairs on Excel

I am working with an Excel file having import and export data between different countries for various shipping products, which looks pretty much like this: The goal is to create a consolidated state pair that have a trade relation between them. So…
S. V.I
  • 1
0
votes
1 answer

VBA::consolidating arrays

I am creating a search function that allows users to search up to 3 different properties at the same time in a database (prop1,2 and 3) and I have created this sub in VBA by putting the results for a searched prop into an array. However, now that I…
Ren-How Harn
  • 1
  • 2
0
votes
2 answers

Trying to consolidate jQuery code

I have loads of code that most need to be loaded BEFORE the other piece of code in order for it to work correctly. In order for me to achieve this I have multiple scripts over and over again. Is there a way I can clean some of this up? I will try…
ToddN
  • 2,901
  • 14
  • 56
  • 96
0
votes
2 answers

How do I open sheets and consolidate them into 1 file with multiple sheets?

I have a user to input 20 store numbers into cells A1 to A20. Cells B1 to B20 will have the hyperlink that each store number has, for example: cell B1 to B20 will have the following formula: =HYPERLINK("C:\"Store Number "&A1&".xls") How do I open…
Cindy
  • 1
0
votes
0 answers

SQL Server: Scripts to perform Object Movement from a database.schema to another

I am new to SQL server. Database: SQL Server 2012, Size 2TB We are planning to consolidate multiple databases.dbo.* objects under a single database as different schemas (databaseN.SchemaN.). Thus we need to prepare scripts to move database1.dbo.…
PrashantLG
  • 1
0
votes
1 answer

SQL: How to consolidate three records into one?

I run a query to produce this. username | userLastFirst | email | approver1 |department MMickie | Mouse, Mickie | abc123@ships.com | Doe, John |HR MMickie | Mouse, Mickie | abc123@ships.com | Smith, Mike …
Vincent Luc
  • 1
  • 1
  • 3
1 2 3
…
10 11