https://community.qlik.com/t5/Official-Support-Articles/Qlik-Replicate-How-to-remove-schema-name-from-the-target-folder/ta-p/2525802 <P>In the target (Azure Data Lake Storage), source tables are replicated with the <FONT face="courier new,courier">schema.table</FONT> name format.</P> <P>To rename the folder name to <FONT face="courier new,courier">tablename&nbsp;</FONT>only, removing&nbsp;<FONT face="courier new,courier">schema</FONT>:</P> <OL> <LI>Create a new <STRONG>Global transformation</STRONG> (see <A href="https://help.qlik.com/en-US/replicate/Content/Global_Common/Content/SharedEMReplicate/Customize%20Tasks/tasks_newTransRuleWiz.htm" target="_blank" rel="noopener">Starting the Global Transformation Rules wizard</A>)</LI> <LI>Choose <STRONG>Rename the schema</STRONG>, click&nbsp;<STRONG>Next</STRONG><BR /><BR /><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="rename schema.png" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/182465iE70908AE24BC349B/image-size/large?v=v2&amp;px=999" role="button" title="rename schema.png" alt="rename schema.png" /></span><BR /><BR /></LI> <LI>Skip the <EM>Transformation Scope </EM>by clicking <STRONG>Next<BR /><BR /></STRONG></LI> <LI>Tick the <STRONG>rename schema to </STRONG>radial (<STRONG>A</STRONG>) and click <STRONG>fx </STRONG>(<STRONG>B</STRONG>)&nbsp;to add the following expression: <PRE>replace($AR_M_SOURCE_SCHEMA,$AR_M_SOURCE_SCHEMA,'')</PRE> <DIV id="tinyMceEditorSonja_Bauernfeind_1" class="mceNonEditable lia-copypaste-placeholder">&nbsp;</DIV> &nbsp;<span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="rename schema to.png" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/182466i3213132571FB425A/image-size/large?v=v2&amp;px=999" role="button" title="rename schema to.png" alt="rename schema to.png" /></span><BR /><BR /></LI> <LI>Click&nbsp;<STRONG>Finish</STRONG> and <STRONG>OK</STRONG></LI> <LI>Save the task and reload</LI> </OL> <P>&nbsp;</P> <H4><FONT color="#339966"><STRONG>Environment</STRONG></FONT></H4> <UL> <LI>Qlik Replicate</LI> </UL> Thu, 31 Jul 2025 14:29:12 GMT Sonja_Bauernfeind 2025-07-31T14:29:12Z https://community.qlik.com/t5/Official-Support-Articles/Qlik-Replicate-How-to-remove-schema-name-from-the-target-folder/ta-p/2525802 <P>In the target (Azure Data Lake Storage), source tables are replicated with the <FONT face="courier new,courier">schema.table</FONT> name format.</P> <P>To rename the folder name to <FONT face="courier new,courier">tablename&nbsp;</FONT>only, removing&nbsp;<FONT face="courier new,courier">schema</FONT>:</P> <OL> <LI>Create a new <STRONG>Global transformation</STRONG> (see <A href="https://help.qlik.com/en-US/replicate/Content/Global_Common/Content/SharedEMReplicate/Customize%20Tasks/tasks_newTransRuleWiz.htm" target="_blank" rel="noopener">Starting the Global Transformation Rules wizard</A>)</LI> <LI>Choose <STRONG>Rename the schema</STRONG>, click&nbsp;<STRONG>Next</STRONG><BR /><BR /><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="rename schema.png" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/182465iE70908AE24BC349B/image-size/large?v=v2&amp;px=999" role="button" title="rename schema.png" alt="rename schema.png" /></span><BR /><BR /></LI> <LI>Skip the <EM>Transformation Scope </EM>by clicking <STRONG>Next<BR /><BR /></STRONG></LI> <LI>Tick the <STRONG>rename schema to </STRONG>radial (<STRONG>A</STRONG>) and click <STRONG>fx </STRONG>(<STRONG>B</STRONG>)&nbsp;to add the following expression: <PRE>replace($AR_M_SOURCE_SCHEMA,$AR_M_SOURCE_SCHEMA,'')</PRE> <DIV id="tinyMceEditorSonja_Bauernfeind_1" class="mceNonEditable lia-copypaste-placeholder">&nbsp;</DIV> &nbsp;<span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="rename schema to.png" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/182466i3213132571FB425A/image-size/large?v=v2&amp;px=999" role="button" title="rename schema to.png" alt="rename schema to.png" /></span><BR /><BR /></LI> <LI>Click&nbsp;<STRONG>Finish</STRONG> and <STRONG>OK</STRONG></LI> <LI>Save the task and reload</LI> </OL> <P>&nbsp;</P> <H4><FONT color="#339966"><STRONG>Environment</STRONG></FONT></H4> <UL> <LI>Qlik Replicate</LI> </UL> Thu, 31 Jul 2025 14:29:12 GMT https://community.qlik.com/t5/Official-Support-Articles/Qlik-Replicate-How-to-remove-schema-name-from-the-target-folder/ta-p/2525802 Sonja_Bauernfeind 2025-07-31T14:29:12Z