NetSuite tWriteJSONField - joining in tMap - not working as per example

Highlighted
Four Stars

NetSuite tWriteJSONField - joining in tMap - not working as per example

Hello,

 

In the Talend help for NetSuite, in the Joining NetSuite objects in Talend section (https://help.talend.com/reader/5LmFvThOiEwYNbu0kj3Rrg/8EvR1rFATwHEq78ClRckcw):

  • they show how an input is passed through to a tWriteJSONField that is itself passed to a tMap component
  • in the tMap component there is a join using a field from the original input

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 ?

 

Screen Shot 2018-02-27 at 8.36.03 AM.png


Accepted Solutions
Community Manager

Re: NetSuite tWriteJSONField - joining in tMap - not working as per example

After you have mapped your tWriteJSONField structure, set the columns you want to return as keys as your group by columns. That will work in this example.

View solution in original post


All Replies
Community Manager

Re: NetSuite tWriteJSONField - joining in tMap - not working as per example

After you have mapped your tWriteJSONField structure, set the columns you want to return as keys as your group by columns. That will work in this example.

View solution in original post

Four Stars

Re: NetSuite tWriteJSONField - joining in tMap - not working as per example

Thanks Richard! It works! Mille merci!

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog