In the Talend help for NetSuite, in the Joining NetSuite objects in Talend section (https://help.talend.com/reader/5LmFvThOiEwYNbu0kj3Rrg/8EvR1rFATwHEq78ClRckcw):
I am unable to successfully do the same as it looks like what is outputted by the tWriteJSONField is only the JSON field and not any of the other "original" fields. Whether I use a inner or left outer join, I do not get anything from the output from the tWriteJSONField field in my tMap result.
Is it even possible to join on a field that was inputted into a tWriteJSONField from the output of the tWriteJSONField in a tMap component or does the tWriteJSONField always only returns what is set in the output column? If the answer to the previous question is that it is not possible, what do you suggest as an alternative to create JSON content and still be able to join on a key ?
Solved! Go to Solution.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema