168 questions
0
votes
1
answer
216
views
Excel Search query cell for multiple values and return those search values from a different table, and return column headers
I'm helping a friend's son with an excel exercise and it has me stumped. I'm not even sure if excel can handle something like this.
We have a column that has multiple cities, and multiple cities ...
1
vote
2
answers
113
views
returning multiple values from multiple functions?
Often, I have main functions that run multiple functions in my common lisp apps.
(main
(run-function-1...)
(run-function-2...)
(run-function-3...)
(run-function-4...)
(run-function-5...))
...
- 1,161
0
votes
1
answer
1k
views
Get multiple value onchange from multiple input Javascript [closed]
I'm trying to get every value from the charge field according to type payment. When both price and pay have a value, the charge input field will be filled by pay - price, and the total amount field ...
- 85
1
vote
0
answers
87
views
How to get an even subsample from a dataframe in R with multiple variable
I have a dataframe with 67 items that looks like this:
df <- data.frame("item"= c("item1", "item2", "item3", "item4", "item5"), "...
- 11
1
vote
1
answer
126
views
How to edit single line XML element with multiple values in c#?
I am editing an existing XML file. I cannot edit an element (the element “range”) that is a multiple value element (a list or an array?), as shown in the XML code below.
<objects>
&...
- 21
1
vote
2
answers
199
views
Return Multiple Values Returned by Another Function Call
In Practical Common Lisp, Peter Seibel write:
The mechanism by which multiple values are returned is implementation dependent just like the mechanism for passing arguments into functions is. Almost ...
- 421
4
votes
5
answers
1k
views
Get indices of matches with a column in a second data.table
I have two data.tables. Each has a column called 'firstName' and another called 'lastName', which contain some values which will match each other and some that won't. Some values in both data sets ...
- 1,075
-1
votes
1
answer
161
views
Remove multiples values of a single key in python dictionary
I have a dictionary which has multiple values for a single key
myDict = {1: {'id1', 'id2', 'id3'}, 2: {'id4', 'id5'}, 3: {'id6'}}
My desired output is
myDict = {1: {'id1'}, 2: {'id4'}, 3: {'id6'}}
...
3
votes
1
answer
384
views
Excel - multiple value search across multiple columns or one column with multiple values
I have 7 criteria = TMO-1 through to TMO-7
I have two scenarios to search from.
i have either got a single excel with TMO-6, TMO-201, TMO-67,... etc (some have a lot of values)
or i have split the ...
- 31
1
vote
2
answers
328
views
How to properly use Common Lisp's multiple-value-bind and handler-case on this HTTP-request interface?
I am using SBCL, Emacs, and Slime. In addition, I am using the library Dexador.
Dexador documentation provides an example on how to handle failed HTTP requests.
From the official documentation, it ...
- 2,671
0
votes
2
answers
722
views
Multiple if conditions with 'more than' and 'less than' values
How do we write these statements and their respective values below using the IF() conditions?
If 0 to equal or less than 8, $0.00
If 9 to equal or less than 18, $10.00
If 19 to equal or less than - ...
0
votes
1
answer
49
views
Input dictionary key to have value be checked somewhere else
I've got another question. You guys have been super helpful.
So I created a dictionary between NFL team names and their codes. The dictionary looks like this:
team_code = []
franchise_list = []
for ...
0
votes
3
answers
332
views
How can I return multiple values from a function?
I'm stuck with functions...
I want to make a function that greets all the names I have in a list in 3 different ways: Good morning, Good afternoon and Good night.
I was able to reach the code below, ...
- 137
0
votes
2
answers
805
views
Jmeter combine Json extractor variables to pass into request
There's a certain web request which has the following response:
{
"data": {
"articles": [
{
"id": "1355",
"slug": &...
- 183
1
vote
1
answer
236
views
Returning multiple values from function (undefined) jQuery/ifelse
I tried to look for an answer before, however, I got stuck.
I'm trying to get multiple values out of the function. Values depend on some other parameters the user chooses. So, within the function ...
- 128
0
votes
2
answers
487
views
Excel - Analyzing / Counting the comma separated values in cells
Here's an Excel sheet, where we track Demand of Products across the countries [Sheet/Table name: Data]
Country
Products
India
A
Australia
A,B
Brazil
B, C
This Data will be used to understand the ...
- 49
0
votes
0
answers
50
views
How to update a value to a appropriate place if the dictionary has single key multiple values?
I have a CSV file with header task;a1_data;a2_data;a3_data. I have considered task as key and rest of the columns as values. a1,a2,a3 are variables here. When the input value is a1 it should update ...
- 1
0
votes
2
answers
285
views
Insert unique random number with recursive MySQL
I want to populate a table with unique random numbers without using a procedure.
I've tried using this reply to do it but not success.
What I'm trying to do is something like this but validating that ...
- 90
0
votes
2
answers
77
views
How to consume only the first returned value in Scheme?
Given a Scheme function returning multiple values, for example:
(exact-integer-sqrt 5) ⇒ 2 1
How can I use only the first returned value, ignoring the other ones?
- 7,784
3
votes
3
answers
3k
views
Insert Into with multiple columns and multiple values in SQL
INSERT INTO MANAGING(SUPID, EMPID)
VALUES (76, 1, 4, 8);
currently this is the code I have, I just simply want to have the 1,4,8 go into the EMPID as three separate values.
Any help would be great, ...
- 33
3
votes
2
answers
5k
views
python replace multiple values from all columns in dataframe pandas
Below is a sample of my table.
Below is the code for the table:
d = {'1978': ['10k', '20000'],
'1979': ['30k', '2M'],
'1980': ['60000', '20k'],
'1981': ['10000', '1M'],
'1982': ['...
- 105
0
votes
1
answer
102
views
Easy method to solve multiplication of many numbers followed by division
Please help for easy method to solve longish multiplications and division equation.
Example like (667 x 6 x 74) / (384 x 384)
Many Thanks in advance
- 7
0
votes
1
answer
34
views
Input line that accepts one and two variables without breaking?
I'm trying to create a "Inventory system" as a beginner proyect. I have a dictionary with string keys and integers values, and I want the program to ask the user what materials he wants to ...
0
votes
1
answer
196
views
Lookup and return another cell value with a gap of cell in between
I am basically stuck in this VBA as I did not know how to lookup 2 cells and return with another cell value. It might be solve with reading project name to lookup first and then reading the week ...
1
vote
1
answer
212
views
Return multiple values from function prototype in C. Results are multiple products
So I have a function prototype find all products from two numbers whether it has 2 or 3 digits. I believe that function can only return one value. So how do I print out all possible values in main ...
- 23
1
vote
1
answer
577
views
Set multiple values in SQL ***make my job easier***
I use the following SQL query in work which works fine, however sometimes I need to update 1000+ values, and doing so one at a time is a laborious process, is there a way to be able to input multiple ...
- 23
0
votes
2
answers
2k
views
Returning multiple values in JS [duplicate]
I was just tweaking some code in JS and ended up writing the below code.
const adding=(a,b,c,d)=> {
return(a+b, c+d)
}
let sum1, sum2 = adding(1,2,3,4)
console.log(sum1)
console.log(sum2)
The ...
- 141
1
vote
1
answer
957
views
Azure Data Factory import multiple valued lookup fields
I need to import data from Sharepoint online list using Azure Data Factory in SQL Azure DB.
The share point online list contained a fields of Lookup type, with options "Allow Multiple Values"...
- 11
0
votes
1
answer
272
views
MS ACCESS - How to filter a splitform's datasheet by a multiple combobox values
I have a splitform with some txtboxes and 1 combobox.
The combobox is related to the same form's query (qryPurchase) and it shows 3 columns of the query fields:
ID_purchase, Purchase_Type, ...
- 113
0
votes
0
answers
43
views
SSMS Parameter with multiple values including NULLs, but NULLs are always included in results even when not selected
I am trying to build an SSRS report with a parameter for File Note Type. The result set has rows with file notes and rows without file notes, so I want the user to be able to select all file note ...
- 23
0
votes
2
answers
201
views
Filter by multiple values and multiple columns
I am trying to make a custom filtering solution within an Excel file, but I'm not sure if it is possible.
I did some research on the Internet, and I came up with the solution from bellow, but when I ...
- 43
1
vote
1
answer
2k
views
Postgresql: how to select from map of multiple values
I have a SOME_DELTA table which records all party related transactions with amount change
Ex.:
PARTY_ID | SOME_DATE | AMOUNT
--------------------------------
party_id_1 | 2019-01-01 | 100
...
5
votes
4
answers
1k
views
How to format a nested multiple-value-bind the let way?
Recently, I've been often nesting several functions that return multiple values. However, unlike let, which me allows to write these calls elegantly into one big statement, I always end up with a lot ...
- 1,169
0
votes
1
answer
532
views
Multiple values in square bracket csv in R [closed]
I have a csv file like this:
1556891503.326399;16384;340;48188.23529411765;[1618.377685546875, 1620.2911376953125, 1620.1904296874998, 1619.9386596679685, 1620.391845703125, 1620.2911376953125, 1620....
- 29
0
votes
1
answer
550
views
How to turn a List<Map<String, String>> with similar keys to a Map<String,List<String>>?
I have the following List -
private MiniProductModel selectedProduct;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
...
- 1,298
0
votes
1
answer
60
views
Using multiple data from a SQL UPDATE query
I am writing data to a temporary table using the query below. For this I use the update command. However, some days the values in the table may be more than one, in which case my update query selects ...
- 3
0
votes
0
answers
547
views
How to do a horizontal index match with multiple values
I'm having trouble getting this formula to run. I need to return multiple values horizontally for work.
I've tried a few formulas online however this seems to be the simplest .
=INDEX($H$2:$H$142,...
- 31
1
vote
1
answer
742
views
Add more values to expression using IIF
I am looking for help updating an expression used in a SSRS report.
The current expression is something like this:
=IIF(Fields!Type.Value = "TKT", "Ticket No.",
IIF(Fields!Type.Value = "CUN", ...
- 682
1
vote
2
answers
1k
views
IF statement for one variable with multiple values
Is there a better way to write this IF statement for testing multiple options of a variable?
<#if PRINTER_PET.RETAILER_NAME = 'BEST BUY' || PRINTER_PET.RETAILER_NAME = 'Best Buy Purchasing LLC'>...
- 11
-1
votes
1
answer
73
views
How to write a function that will output two values in python? [duplicate]
Suppose researchers have analyzed data from the spread of a particular disease and have fit the data to the following model, which predicts the number of people in a small population who will have the ...
- 1
2
votes
2
answers
216
views
Multiple return values of floor in dotimes
The floor Hyperspec article on dotimes has this example:
(defun palindromep (string &optional
(start 0)
(end (length string)))
(dotimes (k ...
- 2,237
-1
votes
1
answer
85
views
return multiple output from option 1 , how to store it at main function and use it for option 3
How can I store the result of getYearOfBirth ,option 1 and 2 to main function and use it for option 3 where to print those result as receipt.
What problem i have found is:
1) if I put , for example :...
- 15
0
votes
1
answer
1k
views
ExtJS - Grid filter with multiple columns and multiple values
I create a grid and a toolbar with Two Menu of menuCheckItem. When i check the menuCheckItem the grid filters even with multiple values and multiple columns.
This working fine, as I have created grid ...
user10386436
0
votes
1
answer
101
views
AJAX POST Send Multiple DIV value
I would like to send my dynamically generated DIV items, but I do not understand how to do it
I create my div dynamically:
$("#clt_forf_ti").click(function(e){
e.preventDefault();
...
- 1
0
votes
1
answer
884
views
How to use bean-shell pre-processor to use multiple extracted values obtained from regex extractor into my next http request ?
I was trying to hit Myntra's home page and search for puma in the search box using JMeter. Using the regEx extractor I extracted few values from the response as shown below:
JMeterVariables:
...
- 152
0
votes
0
answers
211
views
Sort dictionary with multiple values based on sum [duplicate]
I have a dictionary like this
({'Apple': [1,5,3,1,6], 'Banana': [9,12,4,5,1]})
and I want to create a sorted list out of it where sorting is based on the sum of the values.
The following code does ...
user9242224
1
vote
1
answer
218
views
Efficiently computing multiple results
Context
I am currently optimizing a library for scientific computing. I'm fairly new to Commom Lisp. The functions I use are quite small and execute in approx. 10 ns to a few hundred nanoseconds on ...
2
votes
0
answers
42
views
replace multiple column values at the same time
I would like to replace multiple column values at the same time in a dataframe. I would like to change 2 to 1, 1 to 2.
data=data.frmae(store=c(122,323,254,435,654,342,234,344)
,cluster=c(2,2,2,1,1,...
- 1,322
0
votes
1
answer
2k
views
Drupal 8 twig multiple images field
I have a content type with a field field_gallery that has multiple images.
I would like to get all these images printed in my twig file: page--front.html.twig. So i want to get these images in my ...
- 1,129
0
votes
1
answer
2k
views
FnSplit not working for SQL stored procedure to take multiple parameters
I have a stored procedure that currently takes in one value(ChainId) for a parameter. I am trying to allow the user to select multiple values of(ChainId). My where statement is below. Could someone ...
