Stack Overflow
Stack Overflow

Questions tagged [multivalue]

The term "multivalue" refers to a nested data structure where a data column in a database table can contain multiple levels of nested columns.

In some databases, such as the namesake MultiValue database, an example of which is UniVerse, a number of top-level columns can be associated with each other, so that the data in, for example column 1, sub-column 2 has a direct relationship with the data in column 2, sub-column 2.

An example structure could look as follows:

Column one being order numbers, column 2 being order dates and column 3 being part numbers:


Column 1: 00001]00002]00003
Column 2: 26/07/12]27/07/12]28/07/12
Column 3: P123^P124]P125]P126

Multivalue data structures can often lead to excellent performance, one of the reasons being that they eliminate the need for resource consuming table joins.

Apart from the original MultiValue Databases, other examples which use multivalued data structures are many of the NoSQL databases and many Business Intelligence and Reporting tools.

342 questions
0
votes
1 answer

Multiple, multi-value columns in pandas dataset - want to make multiple rows

I have this following dataset from twitter in a pandas DataFrame. app_clicks billed_charge_local_micro billed_engagements card_engagements ... retweets tweets_send unfollows url_clicks 0 None [422040000, 422040000,…
Joe Fedorowicz
  • 625
  • 2
  • 6
  • 14
0
votes
0 answers

Angular material: How to apply sort for table with multiple value in each cell

I use Angular material to make a table whose columns contain multi property value from [dataSource]. I want to make sort for each property in columns. When click to an arrow correspond to a property in a column, the table will be sorted immediately…
Xuan Quang Nguyen
  • 1
  • 2
0
votes
1 answer

Solr 7.3 - Sort conditionally on multi-valued field

I am new to Solr, using Solr 7.3 and I am trying to achieve the following - given a date, I need to retrieve all products which have contracts expiring beyond this date, sorted on the earliest expiring contract, but not considering the already…
Santhosh Korambil
  • 39
  • 6
0
votes
1 answer

micronaut multivalued form field support?

If I send this form to Micronaut with method='GET' then I can extract param1 as a list of two values ... aaa and bbb
Alan Littleford
  • 33
  • 5
0
votes
2 answers

Universe dictionary item extract first character of attribute in a multivalue field

am trying to extract the first character from each subvalue in a record attribute. Thus far am trying REUSE(@RECORD<2>);FIELD(@1,'*',1,1) But it would appear to be returning the first character of the first subvalue. Know this can be done, but…
ScaryMinds
  • 335
  • 3
  • 11
0
votes
3 answers

How to add entries in Pandas DataFrame?

Basically I have census data of US that I have read in Pandas from a csv file. Now I have to write a function that finds counties in a specific manner (not gonna explain that because that's not what the question is about) from the table I have…
Khubaib Khawar
  • 161
  • 1
  • 1
  • 9
0
votes
2 answers

SOLR return a value in multiValue field

I'm newbie in SOLR and I have a problem with multi values field. My document has the following format: { "question":[ "question 1", "question 2". "question 3" "question 4" ], "answer": "Here is the answer" } When I search for the…
Amateur
  • 151
  • 1
  • 2
  • 12
0
votes
2 answers

Building data sets from multiple multivalue records using applys with missing values

I have a SQL Server 2012 database which was imported from a multi-value environment which causes me more headaches than I care to count, however it is what it is and I have to work with it. I am trying to build a data set using these multi value…
Brenns1
  • 37
  • 1
  • 6
0
votes
1 answer

Telerik Reporting How to force the 'Contract' selection whether user selects it or not

I want to force the parameter "Contract" to be returned whether the user selects it from the drop-down list or not.
Craig Zirnheld
  • 139
  • 1
  • 2
  • 13
0
votes
1 answer

Powershell: AD array export auto-generate "pointer"

I would like to export several multi-value "fields" from Microsoft Active Directory. Instead of defining all "array pointers" manually I want to generate them automatically. I already checked Powershell outputting array items when interpolating…
Christian
  • 23
  • 5
0
votes
0 answers

Solr performance when indexing multivaluated indexed field

I'm using SOLR 7.2, and i' trying to index a 133k document with dataimportHandler. The problem is that indexation tooks large time (4 hours), especially after indexing 50k documents. After a large analysis of this problem, I found out that indexed…
beji dhia
  • 111
  • 1
  • 1
  • 7
0
votes
1 answer

How to send multiple selected check box values to a server?

I want to send multiple selected checkbox travel id value to a server. The code is working, but the value is not updating. When the submit button is pressed, I want all the selected checkbox values to be sent to the server and the selected check…
RAJ KUMAR
  • 5
  • 1
  • 7
0
votes
0 answers

SSRS Multivalue parameter contains blanks - Query the blank in multivalue parameter

I have a SSRS multivalue parameter called @prmEstate which is a list of dates. The dataset to populate @prmEstate is select distinct [forecast finish] from table1 The [forecast finish] column contains some blank values. I want to be able to pass…
FoxyB
  • 41
  • 2
  • 3
  • 10
0
votes
1 answer

Checking for SELECT ALL (multi value parameter) in REPORT DATA Query

In the Report Data Query I need to check whether SELECT ALL has been selected in a multivalue parameter. If it has I want to include records where the value for the related field is empty, otherwise I only want to select where the value is in…
Gretz
  • 1
  • 2
0
votes
1 answer

Elastic Search - Matching value inside multi-valued field

I have an ElasticSearch index where documents look like the following: { "labels": ["Common label for doc 1", "Other possible label"], "year": 1923, "boolProp": true }, { "labels": ["Only one label here"], "year": 1812, "boolProp":…
Kevin
  • 63
  • 3
1 2 3
…
22 23