Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

incorrect data in csv file

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

 

0683p000009M2Um.png

 

Expected :

  in place of #N/A  blank value

 

0683p000009M2kY.png

0683p000009M2kd.png

 

Labels (4)
5 Replies
fdenis
Master
Master

is it a question?
Anonymous
Not applicable
Author

Yes.. Of course..
akumar2301
Specialist II
Specialist II

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-componene...

Anonymous
Not applicable
Author

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

 

0683p000009M3MS.png

akumar2301
Specialist II
Specialist II

It is well explained in the link which i gave.