https://community.qlik.com/t5/App-Development/Source-Lookup-with-a-special-character/m-p/1820800#M67286 <P>Hi,</P><P>I am using source_lookup on iSeries database to fetch data from other table. However, the columns contain special characters such as #. The following is a simple source_lookup that is failing to execute:</P><P><SPAN>source_lookup(10000,'SCHEMA','TABLE','COLUMN_NAME','RQMEM#=?',$EMLMEM#)</SPAN></P><P>The Parse expression fails to recognize the # character as a string. I have tried the below as well:</P><P><SPAN>source_lookup(10000,'SCHEMA','TABLE','COLUMN_NAME',</SPAN>'RQMEM#=?',$EMLMEM AND CHR(35)) and get this error "no such function CHR". <LI-PRODUCT title="Qlik Replicate" id="qlikReplicate"></LI-PRODUCT>&nbsp;</P><P>Kindly advise.</P> Thu, 08 Jul 2021 18:53:12 GMT nkare_nts 2021-07-08T18:53:12Z https://community.qlik.com/t5/App-Development/Source-Lookup-with-a-special-character/m-p/1820800#M67286 <P>Hi,</P><P>I am using source_lookup on iSeries database to fetch data from other table. However, the columns contain special characters such as #. The following is a simple source_lookup that is failing to execute:</P><P><SPAN>source_lookup(10000,'SCHEMA','TABLE','COLUMN_NAME','RQMEM#=?',$EMLMEM#)</SPAN></P><P>The Parse expression fails to recognize the # character as a string. I have tried the below as well:</P><P><SPAN>source_lookup(10000,'SCHEMA','TABLE','COLUMN_NAME',</SPAN>'RQMEM#=?',$EMLMEM AND CHR(35)) and get this error "no such function CHR". <LI-PRODUCT title="Qlik Replicate" id="qlikReplicate"></LI-PRODUCT>&nbsp;</P><P>Kindly advise.</P> Thu, 08 Jul 2021 18:53:12 GMT https://community.qlik.com/t5/App-Development/Source-Lookup-with-a-special-character/m-p/1820800#M67286 nkare_nts 2021-07-08T18:53:12Z