how outputting filtered balance results if accountId of DataA is equal to contractorAccountId of DataB? DataA =
Question: how outputting filtered balance results if accountId of DataA is equal to contractorAccountId of DataB?
DataA =
{
“DataA: [
{
"userLoginKey": “08425245”,
"accountId": “p9xxx”
},
{
"userLoginKey": "09953742,
"accountId": "97Exxx”
},
{
"userLoginKey": "77424535”,
"accountId": "jGJjGf"
},
{
"userLoginKey": "08353884”,
"accountId": "IF4Jo7t"
},
{
"userLoginKey": "77167015",
"accountId": "9dReBa"
},
{
"userLoginKey": "7711222",
"accountId": "Sgd4jy"
},
{
"userLoginKey": "7741611",
"accountId": "Sgd4jy"
}
}
DataB =
{
"DataB”: [
{
"contractorAccountId": “p9xxx”,
"balance": 2943
},
{
"contractorAccountId": "97Exxx”,
"balance": 4927529
},
{
"contractorAccountId": "AgPAWl”,
"balance": 1000000
},
{
"contractorAccountId": "97Exxx",
"balance": 957294945
},
{
"contractorAccountId": "p9xxx",
"balance": null
},
{
"contractorAccountId": "Zsrz2M",
"balance": 31116496
},
{
"contractorAccountId": "IF4Jo7t",
"balance": 5
}
}
If p9xxx of accountId is equal to p9xxx of contractorAccountId, make the code, which will create DataC, at this format.
Also, please do not count null of “balance”
p9xxx(DataA) = p9xxx(DataB) → 2943(DataC), but there is no DataC, so the code has to create DataC like this:
DataC =
{
"DataC”: [
{
"balance": 2943
},
{
"balance": 4927529
},
{
"balance": 957294945
},
{
"balance": 5
},
}
Step by step
Solved in 2 steps with 3 images