Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
Si4
Contributor II
Contributor II

tAccessOutput(Access) with comma in field value

This componant seems to be giving me grief.  I am constantly getting index violation warnings when writing to access unless I remove the commas.
I am unsure how to "escape" those commas.

 

For example    value:cn=one,ou=two   

                          causes issues

Try escaping with \, - no change

Try enclosing with quotes "\""  works except the quotes are written to the database

 

Is this possible?

 

Labels (2)
1 Reply
ppatel
Contributor III
Contributor III

Hi,

 

Would you please check if you've configured the component as mentioned in the Talend help document: https://help.talend.com/r/en-US/7.3/access/taccessoutput

 

For now, I am sharing the help document for Talend version 7.3 but based on your Talend version you can select the version and go through the document.

 

Regards,

Pooja Patel