Count for 1 several JSONS with different fields but the same "id"


#1

Hello everyone,
I have a question, I think the anwser is simple but It blocks me for some days.

I need to know if it is possible to count different ID with the field A and field B in different JSONS.
For exemple I have 3 jsons :

JSON 1
{
fieldID: 1
field A : A
}

JSON 2
{
fieldID: 1
field B : B
}
JSON 3
{
fieldID : 2
field A: A
}
How can I made a "count distinct" from ID where there are field A =A AND field B = B ? (for example, in this case, i must have 1 because ID 2 haven't json with field B :B )
I have already try with filter but AND and OR fonctions work only on one JSON. And i have seen nothing about that on website or forum.

If you need more information, don't hesitate
Thank you !


(system) #2

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.