Null values being sorted out to the end

[Polina_1]

Hello everyone. I have an issue - I have a column called apartments_count and it has null values. I generally import data from get request(json). But when I see the imported values in the list, all the null values are in the end and are not in order (it’s like I have a house name and its apartments count, but after getting the data null apartment_count values coming to the end of the list and are being assigned to other houses’ names. What do I do to have them assigned in a right way?

[ArjenEX]

Hi @Polina_1

Welcome! Could you please include a workable (anonymized) json example, what your current output is and what your desired output is. The more you can provide, the better the help will be

This is usually a matter of extracting the data in a particular sequence with the use of node cells to retain the actual position of the null values, but it’s extremely difficult to help you without seeing what you have.

[Polina_1]

My JSON:
“result”: {
“items”: [
{
“name”: “ELEMENT, жилой комплекс”,
“point”: {
“lat”: 43.208409,
“lon”: 76.890869
},
“purpose_name”: “Жилой дом”,
“structure_info”: {
“apartments_count”: 95
},
“type”: “building”
},
{
“name”: “AMIR, жилой комплекс”,
“point”: {
“lat”: 43.207093,
“lon”: 76.894368
},
“purpose_name”: “Жилой дом”,
“structure_info”: {
“apartments_count”: 54
},
“type”: “building”
},
{
“name”: “ESTET, жилой комплекс”,
“point”: {
“lat”: 43.208977,
“lon”: 76.893263
},
“purpose_name”: “Жилой дом”,
“type”: “building”
},
{
“name”: “Braun, жилой комплекс”,
“point”: {
“lat”: 43.200795,
“lon”: 76.896077
},
“purpose_name”: “Жилой дом”,
“structure_info”: {
“apartments_count”: 78
},
“type”: “building”
}
So you see I supposed to have 95, 54, NULL, 78. Instead of this I have this in the table:

The values are being sorted down

[ArjenEX]

Hi @Polina_1

You can achieve this by extracting the data in two steps.

First, get all of the items and output them as (JSON) List by using $['result']['items'][*]

If you then ungroup it you’ll have each item in a separate row.

You can then query all of the individual fields which retains the null values.

[Polina_1]

thank you so much! helped me a lot