Questions tagged [array-column]
The array-column tag has no usage guidance, but it has a tag wiki.
array-column
110
questions
2
votes
3
answers
170
views
Sort a 2D array by column value into recurring ascending groups of not more than N of a kind
I have an array that contains other associative arrays as its values. Each one of these "sub" arrays is mapped with key-value pairs:
$items = [
['type' => 1, 'text' => 'A'],
['...
-1
votes
1
answer
39
views
Pass column from db query result to javascript [duplicate]
I'm trying to write a SQL query to hit my WordPress database as I need some of the info for my front end. However, I'm not getting anything from it. I can see the info in the database itself, so ...
-1
votes
1
answer
75
views
how to match and add column in the multi-dimensional array in PHP
we have to multi-dimensional array and we need to check some value of every element from array 1 to array two on a specific element key.
we can use following code for handle this types of complex ...
0
votes
1
answer
26
views
How to remove duplicate values by comparing two array type column values in Postgresql?
I want to remove duplicate values by comparing two array type column values.
I want to get the result of subtracting the fruit I already ate from my favorite fruit.
But if there ara 2 apples in your ...
1
vote
1
answer
472
views
Populate a flat array of values from a column within a column of a 4-level array
I have this nested multidimensional array for orders
[
[
'created_at' => 1991,
'updated_at' => 1992,
'customer_name' => 'john doe',
'line_items' => [
...
0
votes
1
answer
18
views
json_decode array returns with missing array indexes
I am trying to build a web-gui for jaredhendrickson13/pfsense-api (https://github.com/jaredhendrickson13/pfsense-api)
Either I can't get array indexes on return or they not there.
I am using laravel8 ...
0
votes
1
answer
125
views
How to remove duplicates value of same key of multidimensional array in PHP [duplicate]
I have a multidimensional array and need to remove entries with the same values for a key.
eg.
Array
(
[0] => stdClass Object
(
[id] => 1177930857
[lat] => 24.479280471802
...
0
votes
1
answer
194
views
Use column values from one subarray as keys for anotheer subarray's values
I have an object as below,
{"metaData":[{"name":"a"},{"name":"b"}],"rows":[[1,2],[3,4],[5,6]]}
I would like to change it to
[["a"=...
1
vote
1
answer
383
views
What is PostgreSQL Array Column equivalent in Synapse SQL?
I have a table in PostgreSQL that has array column like abc_id varchar[](1) and it has data in it like {A,B,C}.
I want to create that table in Synapse SQL how can I create array columns is it possible?...
1
vote
2
answers
296
views
Matching vocabulary elements to indices from LDA Model using PySpark
I'd like to take a Spark LDA Model's term indices from the .describeTopics() output and match them to the appropriate term in the count vectorizer's vocabulary. Here is the point of friction:
terms = [...
2
votes
1
answer
2k
views
I am with problems to do a query with array column in PostgreSQL with Spring Data
Entity
I have it entity with a property that is text[]:
@Entity(name = "entityname")
@Table(name = "tablename")
@ToString
@TypeDefs({
@TypeDef(name = "jsonb", ...
1
vote
3
answers
170
views
Get column values from third level of a multidimensional array
I want to get all of the values from an array with 3 levels where the key is age. How can I extract a column of data from a three dimensional array without using a foreach() loop?
My input array:
$...
0
votes
1
answer
651
views
Extract elements from Spark array column using SparklyR "select"
I have a Spark dataframe in a SparklyR interface, and I'm trying to extract elements from an array column.
df <- copy_to(sc, data.frame(A=c(1,2),B=c(3,4))) ## BUILD DATAFRAME
dfnew <- ...
0
votes
1
answer
618
views
How To Search In Multiple Columns In Json File Array?
I have a json file with this content :
[
{
"id": "apple",
"symbol": "app",
"name": "Apple",
},
]
I Want To Search In ...
1
vote
3
answers
53
views
Populate option tags with data- attributes using a multidimensional array
I have a json file that looks something like this:
{
"world": {
"france": {
"city": {
"city_1": {
&...