Data manipulation

Data Manipulation

This is a list of cases how AlaSQL can manipulate JavaScript data (JSON).

Counting:

• How to add own keys for grouped output?
• How to aggregate an array of objects based on object property?
• How to create a cleaned up contact object of an array of contact data?
• How to count matching values in array?
• How to count the number of times each value in the array appears in that array?
• How to count total with two criteria?
• How to extend and merge two arrays containing objects?
• How to intersect arrays of objects based on object property value?
• How to joins and aggregates in Javascript arrays?
• How to filter an array using an array?
• How to find a item based on a key?
• How to find and count unique values in nested JSON objects?

Grouping:

• How to group?
• How to group by array of objects?
• How to group and count?
• How to Group By and Sum?
• How to group arrays by multiple fields?
• How to group javascript object grouped by multiple attributes?
• How to group and sort a JS array?
• How to match the sub property in an objects array?
• How to merge object arrays based on join of a key property in each?
• How to group complex JSON object by nested properties?
• How to SUM and GROUP BY of JSON data?
• How to unique by multiple properties?
• How to use aggregate functions using node-js?
• How to use SQL to query javascript objects?

Other:

• How to restructure an array of strings based on prefix