This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Hi there, I am desperately trying to convert fields (originally from a JSON) from a key value pair to an array. The below table illustrates 3 different events (Record 0, 1 & 2 with associated Event IDs). Each event has associated entities which are impacted by that event, seen in red. The entity ID is currently found in the 'Field Name' field while a '1' represents 'true' and a '0' represents 'false'. I would like the entityID numeral value to show up in the 'Value' field and the 'Field Name' to contain 'entityID' and a count of the number of entities within that record (same as location field). I am able to switch the fields around but battling to get a count on the entityID. Please help if you are able to!