topic Re: incorrect data in csv file in Talend Studio

incorrect data in csv file

Anonymous — Sat, 16 Nov 2024 06:22:18 GMT

I am trying to generate csv file using tsalesforceoutput bulk....the columns which are null suppose to come as blank in csv file but here i am getting #NA

Expected :

in place of #N/A blank value

Re: incorrect data in csv file

fdenis — Mon, 11 Mar 2019 14:12:34 GMT

is it a question?

Re: incorrect data in csv file

Anonymous — Mon, 11 Mar 2019 14:24:40 GMT

Yes.. Of course..

Re: incorrect data in csv file

akumar2301 — Mon, 11 Mar 2019 14:53:48 GMT

It might be coming from INPUT,

in tMap , replace all #N/A with ""/null as you like.

Below could also help.

https://community.talend.com/t5/Design-and-Development/Problem-updating-empty-string-using-componenet-quot/td-p/65545

Re: incorrect data in csv file

Anonymous — Mon, 11 Mar 2019 16:46:21 GMT

in tMap i am no where giving #N/A but it's appearing in csv file...Please look below screenshot

Re: incorrect data in csv file

akumar2301 — Mon, 11 Mar 2019 17:35:43 GMT

It is well explained in the link which i gave.