json in Qliksense

[BI_Dev]

Hi Have data as below.I want to Extract "Name" value from Col B - if the "id" match in Column A & Col B.
Here - the output for Col C would be CAM,RET,INS.

I used JsonGet(Col B, '/items/0/name') to extract "CAM" from Col B.

Col A	Col B	Col C
{	{
"itemValues": [	"items": [
{	{
"id": "k2bzNXcPunqzZpqlo2JBrg",	"id": "k2bzNXcPunqzZpqlo2JBrg",
"status": "Selected"	"name": "CAM"
},	},
{	{
"id": "meoXkB6EXAg1HtEULphIyw",	"id": "meoXkB6EXAg1HtEULphIyw",
"status": "Selected"	"name": "RET"
},	},
{	{
"id": "kR5JqjL50XIgP_a_JQ5B_Q",	"id": "kR5JqjL50XIgP_a_JQ5B_Q",
"status": "Selected"	"name": "INS"
}	},
]	{
}	"id": "os5u2-KW9aOm8wuat_RJDQ",
	"name": "Water"
	},
	{
	"id": "vlluUqoAUcTfuqVcXJZC7Q",
	"name": "Electricity"
	},
	{
	"id": "qYaD20UYW7-NiZUDErlAtg",
	"name": "Security"
	},
	{
	"id": "jQrI9N1nlzjqYPhdablDMg",
	"name": "Parking"
	},
	{
	"id": "gGweWt_WEt05FJowTPRJNQ",
	"name": "Utilities"
	},
	{
	"id": "pMPGWzEXfZNHbmg0rf5OUw",
	"name": "Other"
	}
	]
	}

[JordyWegman]

Hi,

Can you maybe share the normal JSON files?

Jordy

Climber