Joining a JSON Array

[PITadmin]

Hi,

I failing to join an JSON array with other data.

I want to join the tables A and B on UnitIDs:

A) (from a tExtractJSONFields)

UnitIDs; Name

[1,5]; Steve

[20,3];John

B)

(from a tExtractJSONFields)

UnitID; Unitname

5; Unit05

3;Unit03

The Result should be:

UnitID; Name; UnitName

5; Steve; Unit05

3; John; Unit03

but my Join inside the tMAP fails to deliver Data?

Can anyone help?

regards

Stefan

[Anonymous]

Hello

Could you please post your job setting screenshots here which will be helpful for us to address your issue?

Best regards

Sabrina

[Anonymous]

It would be great if you could explain your task a little bit deeper. You speak about json. How the input and output structure should looks like?