Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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