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 !