Hi All,
I have 2 data json and i want to combine the data based on id. But i want to put condition too.
1. If id = r9e630dc34f894c00a91d4a18760d2938, then Company name and show the value
2. If id = r6be76015c5b64720970edd574eb8f2e1, then Location name and show the value
3. If id = r88174066e8724d3995f5617e12fd47de, then Assessment Date and show the value
4. Value score get from answer 1 -> displayText
4. And my expectation result like this :
First output Json :
{
"body": [
{
"title": "Company Name",
"headerTitle": "",
"id": "r9e630dc34f894c00a91d4a18760d2938"
},
{
"title": "",
"headerTitle": "",
"id": "r6be76015c5b64720970edd574eb8f2e1"
},
{
"title": "Assessment Date",
"headerTitle": "",
"id": "r88174066e8724d3995f5617e12fd47de"
},
{
"title": "Master Data - Asset Register",
"headerTitle": "",
"id": "r5ca2170d7e0a406dbb245a66f6e67a34"
},
{
"title": "Apakah list/ daftar unit tersedia (Machine Population)?",
"headerTitle": "Master Data - Asset Register",
"id": "r55dd5fc01f0d4ed09c8dc3ccdc5f78f9"
},
{
"title": "Apakah penomoran unit menggunakan standard numbering system atau naming convention untuk penamaan unit tersedia?",
"headerTitle": "Master Data - Asset Register",
"id": "rf7c8bd7b29024029b759b88e3203b4f2"
},
{
"title": "Apakah informasi tentang Unit/ Asset/ Equipment tersedia? (Model, Type, Class, Manufacturer, Quantity, Location, Life to date (hr, year), Status, etc.) ",
"headerTitle": "Master Data - Asset Register",
"id": "r554fa5aaff5742ac94c99992ac7a49ae"
},
{
"title": "Apakah parameter dan penentuan asset criticality, criteria, & hierarchy tersedia dan diimplementasikan untuk semua asset?",
"headerTitle": "Master Data - Asset Register",
"id": "r93af850c05ae4214a9455c03fe7d6c8e"
},
{
"title": "Apakah child asset swapped (perpindahan sub asset) dilakukan?",
"headerTitle": "Master Data - Asset Register",
"id": "r2b52c34da16d44319bf92f1c73d2f4b2"
},
{
"title": "Apakah Asset Serialized diimplementasikan?",
"headerTitle": "Master Data - Asset Register",
"id": "rfdf5533e3f3c466b8a14cfc5eb4e8875"
},
{
"title": "Bagaimana cost structure untuk maintenance? (Cart of Accounting - COA for maintenance )",
"headerTitle": "Planning, Budgeting, & Cost - Policy & Process",
"id": "rd0c33049e201457ea6ec18669c666954"
},
{
"title": "Apakah concept depreciation diterapkan? (depreciation method dan policy)",
"headerTitle": "Planning, Budgeting, & Cost - Policy & Process",
"id": "r8fd0699d9a914d1b892eccc9ca3a930c"
},
{
"title": "Planning, Budgeting, & Cost - Team",
"headerTitle": "",
"id": "rac50aac902684ebdb97636e1e08152dc"
}
]
}
Second output JSON :
[
{
"answer1": "PT. BBB",
"questionId": "r9e630dc34f894c00a91d4a18760d2938"
}
,
{
"answer1": "Banten",
"questionId": "r6be76015c5b64720970edd574eb8f2e1"
},
{
"answer1": "2024-06-26",
"questionId": "r88174066e8724d3995f5617e12fd47de"
},
{
"answer1": "",
"questionId": "r5ca2170d7e0a406dbb245a66f6e67a34"
},
{
"answer1": {
"id": 2,
"order": 1,
"displayText": "0",
"description": null,
"isCustomChoice": false,
"customProperties": "{\"FormsProDisplayRTText\":\"0\"}",
"key": "40b17175-fbdc-495a-a7d1-cc2bd2069013",
"formsProDisplayRTText": null
},
"questionId": "r55dd5fc01f0d4ed09c8dc3ccdc5f78f9"
},
{
"answer1": {
"id": 3,
"order": 2,
"displayText": "50",
"description": null,
"isCustomChoice": false,
"customProperties": "{\"FormsProDisplayRTText\":\"50\"}",
"key": "bba2ed88-1c1f-4c4b-a3d9-824a5dbe8338",
"formsProDisplayRTText": null
},
"questionId": "rf7c8bd7b29024029b759b88e3203b4f2"
},
{
"answer1": {
"id": 2,
"order": 1,
"displayText": "0",
"description": null,
"isCustomChoice": false,
"customProperties": "{\"FormsProDisplayRTText\":\"0\"}",
"key": "40b17175-fbdc-495a-a7d1-cc2bd2069013",
"formsProDisplayRTText": null
},
"questionId": "r554fa5aaff5742ac94c99992ac7a49ae"
},
{
"answer1": {
"id": 3,
"order": 2,
"displayText": "50",
"description": null,
"isCustomChoice": false,
"customProperties": "{\"FormsProDisplayRTText\":\"50\"}",
"key": "bba2ed88-1c1f-4c4b-a3d9-824a5dbe8338",
"formsProDisplayRTText": null
},
"questionId": "r93af850c05ae4214a9455c03fe7d6c8e"
},
{
"answer1": {
"id": 4,
"order": 3,
"displayText": "100",
"description": null,
"isCustomChoice": false,
"customProperties": "{\"FormsProDisplayRTText\":\"100\"}",
"key": "ecf18409-62bb-4051-b8b2-cc0b303ab4b9",
"formsProDisplayRTText": null
},
"questionId": "r2b52c34da16d44319bf92f1c73d2f4b2"
},
{
"answer1": {
"id": 4,
"order": 3,
"displayText": "100",
"description": null,
"isCustomChoice": false,
"customProperties": "{\"FormsProDisplayRTText\":\"100\"}",
"key": "ecf18409-62bb-4051-b8b2-cc0b303ab4b9",
"formsProDisplayRTText": null
},
"questionId": "rfdf5533e3f3c466b8a14cfc5eb4e8875"
},
{
"answer1": "",
"questionId": "rd0c33049e201457ea6ec18669c666954"
},
{
"answer1": "",
"questionId": "r8fd0699d9a914d1b892eccc9ca3a930c"
},
{
"answer1": "",
"questionId": "rac50aac902684ebdb97636e1e08152dc"
}
]
