Hi everyone!
I have a file with an array of objects, that host information about different fields - what is there value, have this value changed, etc.
For example:
"changedFieldsList": [
{
"fieldId": "PK_NEWJOURNAL",
"fieldType": "NUMBER",
"fieldValue": "NULL",
"fieldChanged": "Y"
},
{
"fieldId": "OFFICE",
"fieldType": "CHAR",
"fieldValue": "NULL",
"fieldChanged": "Y"
},
{
"fieldId": "UPDATE_DATE",
"fieldType": "DATE",
"fieldValue": "2017-12-07 05:09:54+03:000",
"fieldChanged": "Y"
},
...
The problem is that this structure is making aggregation problems because the names of the fields are the same.
If I want to flat the file in order to have unique field names, is there a way to tag a specific field and add metadata to a field so I still can tell if the field have changed or any other useful metadata, without adding new fields?