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

Where within case en multi velues return

How can i make this work where case [a].[ndex] when [b].[aantal] = 0 then 0 when [b].[aantal] = 1 then 0 and 1 when [b].[aantal] = 2 then 0 and 1 and 2 end
user2275634
  • 13
  • 4
0
votes
1 answer

Expand two Excel columns, each with multiple corresponding values

How can I turn this excel table Country Initiative Staff involved Billing hours HK Data Lake Amy, Ben, Li 6,3,8 into this using Excel/ Python/ Power query? (not necessarily 3 staffs, can more more or less) Country Initiative Staff…
Crystal Kwan
  • 31
  • 5
0
votes
1 answer

Querying full and sub-strings via multi-valued parameter using SQL

I am building a report with Microsoft SSRS (2012) having a multi-value parameter @parCode for the user to filter for certain codes. This works perfectly fine. Generally, my query looks like this: SELECT ... FROM ... WHERE TblCode.Code IN…
Wellenprinz
  • 1
0
votes
1 answer

What's another programmatic method to remove attachment(s) on a Access Form's Attachment Control?

My Access form has an attachment control, and I want to give the users the ability to overwrite one of a record's files with another copy from their drive. Here's a snippet from my code: Dim cdb As DAO.Database, rstMain As DAO.Recordset, rstAttach…
Shawn V. Wilson
  • 1,002
  • 3
  • 17
  • 42
0
votes
1 answer

Problem with paramter popup with multi-value field in MS Access SQL

I have the following SQL query: FROM Registration AS r WHERE r.RegisteredFor.Value=[Forms]![RunQueries]![filterBy]; When I run this query it reports back fine, however, when I run a second query which uses this query, so for example: SELECT…
terrarium
  • 1
  • 1
0
votes
1 answer

Constructing multi-value JSON for Rails

I have the following javascript object containing a multi-value email property: var contact = { email = { home = ( "me@home.com" ); work = ( "me@work.com" ); }; …
Micah Alcorn
  • 2,363
  • 2
  • 22
  • 45
0
votes
1 answer

sort multi value column in oracle table

I'm trying to sort on a column in oracle table. The column value is 'M013,M007,M019,YYY,M018,XXX,999'. I'm trying to sort the values with in the column before comparing it to another column which already has the data sorted. I've tried multiple…
Chase Dan
  • 3
  • 1
0
votes
2 answers

Reporting Services problem. Forward dependencies are not valid

I have a problem with a Reporting Services report. My report has two datasets, one that fetches the actual report data and one that fetches translated resource strings for displaying wherever literal text is used on the report. This dataset requires…
Steve Crane
  • 4,340
  • 5
  • 40
  • 63
0
votes
3 answers

Multi-dimensional search on a table

I have the following table that stores the preferences of the users in the system UserId | Product | Brand | City | ------------------------------------------- A | Soap | Tide | NYC | A | Cereal | Dont-care |…
calvinkrishy
  • 3,798
  • 8
  • 30
  • 45
0
votes
1 answer

How to split a form field to display multiple values in Django

My Journey model contains two fields, distance and time: class Journey(models.Model): distance = models.PositiveIntegerField(default=0) time = models.PositiveIntegerField(default=0) I am trying to create a Modelform where the time field…
sgt_pepper85
  • 421
  • 4
  • 14
0
votes
1 answer

preserve association or position in multivalued in solr

I have multivalued fields in my solr datasource. sample is 23606 2020-05-24 2018-01-18 1997-07-22
sergio briano
  • 23
  • 7
0
votes
0 answers

SSRS Hide columns based on Multi valued parameter

I have an SSRS report that has two parameters. A Description and Partner name. You can select more than one description or all of them but only one partner. When i select one or more descriptions report must only show columns that have values. Issue…
Siyanda Sikhosana
  • 1
0
votes
1 answer

Splitting multiple multi-valued cells in excel into rows

I'm looking to split rows of multiple multi-valued cells into separate rows so that each of the row has one value from each of the multi-valued cells. For instance if I have the following rows: > Column1 Column2 Column3 > 1 A:B:C …
Dilip T Monson
  • 75
  • 3
  • 9
0
votes
1 answer

.NET and Multivalue D3

I read this forum for years, but this is the first question that I made here, I use a Multivalue DataBase with D3, I want to know how which its the best way to connect with Multivalue database from .net application, I want to get information for D3…
Jorge Marcos
  • 1
0
votes
2 answers

XSL Create New Element from MultipleXML Fields including some with the Same Name

I'm trying to create a new XML element by joining multiple elements (some with the same name) into a new element. I'm able to create a new element by joining the Publisher elements, but I'm not sure how to proceed. The end result would be a new |…
Hammer Time
  • 33
  • 6
1 2 3
…
22 23