Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hello
Could you please post your job setting screenshots here which will be helpful for us to address your issue?
Best regards
Sabrina
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?