https://community.qlik.com/t5/Installing-and-Upgrading/Allow-specific-characters-for-columns-in-schema-s-doesn-t-work/m-p/2352994#M1200 <P>Hi,</P><P>Yes i'm using TOS for DI 6.5.1</P><P>Best regard</P><P>Yannick</P> Tue, 06 Nov 2018 08:21:56 GMT Anonymous 2018-11-06T08:21:56Z https://community.qlik.com/t5/Installing-and-Upgrading/Allow-specific-characters-for-columns-in-schema-s-doesn-t-work/m-p/2352990#M1196 <P>Hi,</P> <P>Before upgrading to Talend 6.5.1 on LINUX, i was working with Talend 4.1.2 on Windows and i had no problems with column names containing $ (in an ORACLE database). When i retrieved or updated metadata, $ was not replaced by an _ :</P> <P>&nbsp;</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Here is an example with $ in column and DB column" style="width: 911px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M0DY.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/139429i1D6A7A8AF100E327/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M0DY.png" alt="0683p000009M0DY.png" /></span><SPAN class="lia-inline-image-caption" onclick="event.preventDefault();">Here is an example with $ in column and DB column</SPAN></SPAN></P> <P>Now in Talend 6.5.1 :</P> <P>&nbsp;</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Now DB column contains $ but column contain _" style="width: 915px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M0UY.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/155121i6F1735D029609942/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M0UY.png" alt="0683p000009M0UY.png" /></span><SPAN class="lia-inline-image-caption" onclick="event.preventDefault();">Now DB column contains $ but column contain _</SPAN></SPAN><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="The allow specific characters for columns of schemas is enabled" style="width: 637px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M0Ud.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/157644iADA7D3EC76A15F6C/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M0Ud.png" alt="0683p000009M0Ud.png" /></span><SPAN class="lia-inline-image-caption" onclick="event.preventDefault();">The allow specific characters for columns of schemas is enabled</SPAN></SPAN></P> <P>Why special character $ is replaced by _. Is it due to charset ?</P> <P>Thank you for help</P> Sat, 16 Nov 2024 07:27:49 GMT https://community.qlik.com/t5/Installing-and-Upgrading/Allow-specific-characters-for-columns-in-schema-s-doesn-t-work/m-p/2352990#M1196 Anonymous 2024-11-16T07:27:49Z https://community.qlik.com/t5/Installing-and-Upgrading/Allow-specific-characters-for-columns-in-schema-s-doesn-t-work/m-p/2352991#M1197 <P>Hello,</P> <P>Since Talend don't support the special characters like&nbsp; "$" in the column name, it will replace automatically "$" with "_" when retrieving schema. Have you tried to generate the 1st line with a tFixedFlowInput and complete your file without column titles?</P> <P>Best regards</P> <P>Sabrina</P> Wed, 24 Oct 2018 07:23:36 GMT https://community.qlik.com/t5/Installing-and-Upgrading/Allow-specific-characters-for-columns-in-schema-s-doesn-t-work/m-p/2352991#M1197 Anonymous 2018-10-24T07:23:36Z https://community.qlik.com/t5/Installing-and-Upgrading/Allow-specific-characters-for-columns-in-schema-s-doesn-t-work/m-p/2352992#M1198 <P>Hello,</P> <P>My problem is that all my projects (about 100/200 jobs) includes tOracleInput with schema where the "$" was not replaced (in column name and DB column name) by an "_" because it was supported. Now, each time i update a database schema, i have to modify each job that uses this schema because in the first tMap coming after the tOracleInput, the input and output columns are not connected anymore.</P> <P>best regard</P> Fri, 26 Oct 2018 14:55:45 GMT https://community.qlik.com/t5/Installing-and-Upgrading/Allow-specific-characters-for-columns-in-schema-s-doesn-t-work/m-p/2352992#M1198 Anonymous 2018-10-26T14:55:45Z https://community.qlik.com/t5/Installing-and-Upgrading/Allow-specific-characters-for-columns-in-schema-s-doesn-t-work/m-p/2352993#M1199 <P>Hello,</P> <P>The "Allow specifc characters" option&nbsp; is mostly used to allow at least like chinese or japanese characters.</P> <P>Are you using talend open studio V 6.5?</P> <P>Best regards</P> <P>Sabrina</P> Tue, 06 Nov 2018 07:23:58 GMT https://community.qlik.com/t5/Installing-and-Upgrading/Allow-specific-characters-for-columns-in-schema-s-doesn-t-work/m-p/2352993#M1199 Anonymous 2018-11-06T07:23:58Z https://community.qlik.com/t5/Installing-and-Upgrading/Allow-specific-characters-for-columns-in-schema-s-doesn-t-work/m-p/2352994#M1200 <P>Hi,</P><P>Yes i'm using TOS for DI 6.5.1</P><P>Best regard</P><P>Yannick</P> Tue, 06 Nov 2018 08:21:56 GMT https://community.qlik.com/t5/Installing-and-Upgrading/Allow-specific-characters-for-columns-in-schema-s-doesn-t-work/m-p/2352994#M1200 Anonymous 2018-11-06T08:21:56Z https://community.qlik.com/t5/Installing-and-Upgrading/Allow-specific-characters-for-columns-in-schema-s-doesn-t-work/m-p/2352995#M1201 <P>Hello,</P> <P>We will make an investigation on your issue to see if there is a workaround and then come back to you as soon as we can.</P> <P>Best regards</P> <P>Sabrina</P> Tue, 06 Nov 2018 09:24:50 GMT https://community.qlik.com/t5/Installing-and-Upgrading/Allow-specific-characters-for-columns-in-schema-s-doesn-t-work/m-p/2352995#M1201 Anonymous 2018-11-06T09:24:50Z