All Questions
25,503
questions
1
vote
2
answers
38
views
How to count values from a column with JSON content?
I have a table with singers and each singer can be linked to many musical styles.
Musical Styles are in a TEXT column, but the content of the column has JSON format.
I want to count the number of ...
- 101
0
votes
1
answer
28
views
CSV backslash create issue while procession file data
I am trying to process a CSV file in which one column contains JSON formatted data. In this JSON data, some fields use backslashes, which creates a problem when mapping fields with their values.
Link ...
- 130
2
votes
1
answer
28
views
Extract Unique Values from a Power BI JSON in Power Automate
I have the following JSON that comes from PowerBI (via the Power Automate button function)
[
{
"entity": {
"Power BI values": [
{
"G-DATEMO":...
- 39
1
vote
1
answer
61
views
Converting a flat file into JSON structure using ADF (Azure Data Factory)
I have a flat file which contains information such as names, addresses, mobile numbers, email addresses, etc. We want to convert this into a JSON-structured output. I have created a data flow which is ...
- 77
-1
votes
0
answers
20
views
understanding json_decode data [duplicate]
When I use json_decode and look at the results, I get a list of objects and arrays. I specifically want to retrieve one piece of information, but I'm not sure how to get it. I seem to have a stdClass ...
- 1
-1
votes
0
answers
39
views
How to convert complex JSON with list of arrays to table format in ADF
We have an unusually formatted JSON file to convert into a table format using Microsoft Azure Data Factory (ADF). I've had a few attempts using the flatten and aggregate components, but haven't been ...
- 1
-4
votes
0
answers
54
views
how to write this row mapper in better way [closed]
'm working on a Spring Batch application and have implemented a custom Partitioner to divide processing across multiple threads. I'm having trouble writing a JUnit 4 test for my partition method. I've ...
0
votes
0
answers
47
views
Return the latest group of records inserted by specifically me into a table along with their ID in the table?
I have a table of Customers, named Customer with the following columns:
CustomerID
CustomerName
ContactNo
Address
DateCreated
1
Idola Steenson
438614198
Morena
2022-08-14 09:48:00
2
Graham Buckner
...
0
votes
0
answers
36
views
Typescript Json get value [duplicate]
I'm getting from api {"bmw":[{"year":2022, "color": "black", "perfs":{"bmw":{"model": "x5", "county": "...
0
votes
0
answers
13
views
Mixed bracket types. Is this json or something else?
I am trying to parse data from a URL. I think it looks like json but I'm not sure. The URL also doesn't end in .json (something like https://google.com/file).
The format of the data on the page looks ...
- 25
0
votes
0
answers
21
views
Create mysql table from json string when 1st dimension hold columns and 2nd dimension holds rows
I am sitting with a legacy database and im trying to create this table in mysql using json strings stored in the database.
I have a table that stores a massive json string and one of the keys inside ...
- 1
-3
votes
1
answer
43
views
Filter/Remove array object based on value, from nested JSON array object in JavaScript
I have a filter criteria to apply on REST response. This response have nested sub objects. For loop going in task and filter function is not working on nested array objects. Please help me to filter ...
1
vote
1
answer
37
views
How to add object values from an array of multiple objects into an array readable for ngFor?
I get an array like this:
obj_Array = [{"Information":{ID: 1, Name: "Frank"}},"Route":{Direction: "north", Time: 10:50:24},"Music":{volume: "loud&...
- 81
-1
votes
0
answers
19
views
AsyncStorage React Native how can i store an object with multiple arrays inside?
i have been using asyncstore these days in react native and it works okay when storing tokens and simple objects. But i has a model like this (an object with arrays inside)
"_id": {
&...
2
votes
1
answer
36
views
Jmeter: unable to extract value from nested array
I am trying to automate load testing on Jmeter in order to be able to schedule them and let them run at specific times. I have no powers over the queues nor our rabbit scenery in general, I can only ...
- 25