Display the duplicate values once and list out any unique changes beneath each repeated value

Question

Display the duplicate values once and list out any unique changes beneath each repeated value

I have a complex query that involves select distinct of multiple columns, joins, and where clause. However, the results are showing repeated values with different dates as follows:

ID  title   Date    other field
1   text 1  01-Jan-20   another value
1   text 1  07-Mar-20   another value
1   text 1  20-Sep-20   another value
1   text 1  30-Dec-20   another value
2   text 2  02-Feb-20   something else
2   text 2  12-Mar-20   something else
2   text 2  15-May-20   something else
2   text 2  17-Jul-20   something else

I want to display only unique values once along with the changing dates like this:

1, text, another value
01-Jan-20
07-Mar-20
20-Sep-20
30-Dec-20

2, text, something else
02-Feb-20
12-Mar-20
15-May-20
17-Jul-20

Should I modify the oracle query or utilize map/reduce on the resulting array in my programming language? Any suggestions or examples?

javascript arrays oracle-database

Answer 1

Answer №1

Here is a coding example

let dataObject = {};
`1   text 1  01-Jan-20   another value
1   text 1  07-Mar-20   another value
1   text 1  20-Sep-20   another value
1   text 1  30-Dec-20   another value
2   text 2  02-Feb-20   something else
2   text 2  12-Mar-20   something else
2   text 2  15-May-20   something else
2   text 2  17-Jul-20   something else`.split(/\n/)
.forEach(line => {
  let [_, num, title, date, val] = line.match(/(\d+)\s+(.*?)  (.*?)   (.*)/)
  // console.log("n",num,"t",title,"d", date, "v",val)
  if (!dataObject[title]) dataObject[title] = { num:num, val:val,dates:[] }
  dataObject[title].dates.push(date)
})

console.log(dataObject)

Answer 2

Here is a coding example

let dataObject = {};
`1   text 1  01-Jan-20   another value
1   text 1  07-Mar-20   another value
1   text 1  20-Sep-20   another value
1   text 1  30-Dec-20   another value
2   text 2  02-Feb-20   something else
2   text 2  12-Mar-20   something else
2   text 2  15-May-20   something else
2   text 2  17-Jul-20   something else`.split(/\n/)
.forEach(line => {
  let [_, num, title, date, val] = line.match(/(\d+)\s+(.*?)  (.*?)   (.*)/)
  // console.log("n",num,"t",title,"d", date, "v",val)
  if (!dataObject[title]) dataObject[title] = { num:num, val:val,dates:[] }
  dataObject[title].dates.push(date)
})

console.log(dataObject)

Display the duplicate values once and list out any unique changes beneath each repeated value

Answer №1

Similar questions

JavaScript and Responsive Design Techniques

Guide to building an HTML table using an array of objects

The concept of setTimeout and how it affects binding in JavaScript

Is it possible for the JTable constructor to accept data structures other than arrays?

Traverse the JSON array in a loop

What is the method to spin an item in three js while keeping its axis in focus?

Create a new object by mapping values from an array of two objects in Angular using TypeScript, based on the object

When using array_intersect, an error with Severity 4096 occurs stating that a stdClass object could not be converted to a string in the CodeIgniter

creating a picture within a frame

Using React js to transform objects into arrays for useState

Is it feasible to simultaneously load multiple directives in AngularJS?

Navigating fluently in React Native applications

Angular JS effectively prevents redundant data from being displayed to users when scrolling infinitely while also efficiently removing DOM elements for previous data

Transferring data between two TypeScript files of different Angular 2 components

The webpage does not dynamically resize based on screen height

Utilizing D3 for embedding a background image in an SVG

Display Buttons in a Horizontal Row and Highlight the Active Button

what is the significance of the number THREE in the context of Three.js?

Adding images dynamically into a Bootstrap modal when clicking using Angular's ng-repeat

Troubleshooting API URL parameter problems