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

Getting " MultiValueDictKeyError at /button/ 'text " error in a Django project

Tring to create a demo Todo web app using Django and Bootstrap, Whenever I am trying to trigger a function using a button it's raising a "MultiValueDictKeyError at /button/" Error. I have set an input form name "text" and receiving it This is the…
Tahsin Ahmed
  • 21
  • 5
0
votes
1 answer

How to pass multi-parameter to django url and how to reverse it

i am trying to make quiz app, i want make user to select subjects and topic and number of questions(genrate quiz). after input next view should be test/quiz .i am unable to pass the multiple parameter/values to django url. (e.g…
drnewbie
  • 11
  • 2
0
votes
1 answer

Cannot Create MultiValueControl in TFS 2017

I am updating existing Workitem Template to have a new field that should be "MultiLineControl". Below is what all i did. 1) Changed WorkItem template as …
user3182464
  • 53
  • 1
  • 8
0
votes
1 answer

Query a multi-valued column

I have a multi-valued column , MISC_CONTENT with the following string in the column: amount = 7995 ;channel = SXXXN21 ;group_header = NPS099 ;currency = EUR How can retrieve the value NPS099 by lookup with group_header?
user2102665
  • 429
  • 2
  • 11
  • 26
0
votes
1 answer

How do I Loop through a multi-value People Field or Lookup field in SharePoint 2013 designer using REST

I have a multi-valued people picker and a multi-valued Lookup field that I need to read all the entries in a 2013 workflow. I know how to create a workflow that retrieves the data and iterate through each list item using REST and a dictionary. …
Steve Harvancik
  • 93
  • 1
  • 8
0
votes
1 answer

Multivalue row count in MySQL Query

Input: col1 a,b a,c Output: col1 count a 2 b 1 c 1 I want to simply count multivalue rows in MySQL Query.
lil-wolf
  • 372
  • 2
  • 15
0
votes
4 answers

HOW TO query multi-valued column by key in SQL SERVER

How to query a multivalued column for a specific key? Sample Data ID DAY PRICE 1 01;02;03;04;... 100;230;110;34.5;... 2 01;02;03;04;... 120;240;510;34.5;... For example: select ... where DAY key = '02' Expected: ID DAY…
Charles Okwuagwu
  • 10,538
  • 16
  • 87
  • 157
0
votes
1 answer

Parse Nested JSON Array into Splunk Table

I have the below JSON event with nested array in splunk -: { "items": [ { "parts": [ { "code":"1","var":"","pNum":"101","counter":1019 }, …
Kripz
  • 166
  • 3
  • 7
0
votes
0 answers

Search Multiple Fields in Access

I've been trying to make the value from a text box search across all fields in my form "Dashboard". The dashboard has 15 fields to search through. I've gone online and tried every example but none seem to work for me. Below is the code that has come…
mightymax
  • 431
  • 1
  • 5
  • 16
0
votes
1 answer

Confused about junction table implementation

First things first, I'm not a programmer and this is the first time I've worked with database creation and this implementation is part of a need that was identified during the internship that I'm currently doing. I'm currently developing an MS…
Javier 82
  • 3
  • 2
0
votes
1 answer

how does laravel handle multivalued attributes in table?

i realized that "interest_amount" on my "loan" table is multi-valued attribute. so should i just create a table to split "loan" table or should i create a different model? i need different table for "interest" since i have to mark each month's…
Prithvi Tuladhar
  • 73
  • 10
0
votes
1 answer

Access 2016 VBA unable to set button click on form to write multi-value fields to second table

I am building an application to track time amongst project, employees, etc. The company I work for has significant security red tape, so I have to use MS Access 2016, I am barred from youtube to search solutions, and I cannot download any files…
CircularReference
  • 7
  • 1
  • 9
0
votes
1 answer

Teradata Compression Tools

Any recommend multi value compression tools for Teradata? (Except from Atana Suite and Prise Tools. Their trial versions do not show output or enough test to get convinced that I should aquire this)
lulu
  • 1
0
votes
1 answer

Oracle multivalue groups

I have a table with 2 multi value fields for example: 1st row contains these fields: field 1: 1,4,5 field 2: 1,2,3 second row contains: field 1: 5,6,7 field 2: ,6,3 third row: field 1: 8,,9 field 2: 1,,3 |---------------------|------------------| |…
Beyond1337
  • 3
  • 1
  • 4
0
votes
1 answer

MS Access Multiple value from a FORM into table as a Single Line

To avoid Multiple Value fields, I need some help to configure the "multi-select" option of a FORM within MS Access to a SINGLE line/field. Example: And in the Table it should come out like one single line/field Example Is this even possible? if…
Chamopak
  • 3
  • 3
1 2 3
…
22 23