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
},
}
![](/static/compass_v2/shared-icons/check-mark.png)
Step by step
Solved in 2 steps with 3 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![Database System Concepts](https://www.bartleby.com/isbn_cover_images/9780078022159/9780078022159_smallCoverImage.jpg)
![Starting Out with Python (4th Edition)](https://www.bartleby.com/isbn_cover_images/9780134444321/9780134444321_smallCoverImage.gif)
![Digital Fundamentals (11th Edition)](https://www.bartleby.com/isbn_cover_images/9780132737968/9780132737968_smallCoverImage.gif)
![Database System Concepts](https://www.bartleby.com/isbn_cover_images/9780078022159/9780078022159_smallCoverImage.jpg)
![Starting Out with Python (4th Edition)](https://www.bartleby.com/isbn_cover_images/9780134444321/9780134444321_smallCoverImage.gif)
![Digital Fundamentals (11th Edition)](https://www.bartleby.com/isbn_cover_images/9780132737968/9780132737968_smallCoverImage.gif)
![C How to Program (8th Edition)](https://www.bartleby.com/isbn_cover_images/9780133976892/9780133976892_smallCoverImage.gif)
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781337627900/9781337627900_smallCoverImage.gif)
![Programmable Logic Controllers](https://www.bartleby.com/isbn_cover_images/9780073373843/9780073373843_smallCoverImage.gif)