https://community.qlik.com/t5/Official-Support-Articles/Unable-to-translate-data-type-from-Oracle-SQL-views-and-unable/ta-p/1948090 <P>Replicating data from Oracle SQL views (with few fields defaulted to NULL explicitly) into snowflake fails to create table in Snowflake.</P> <P><STRONG>Environment</STRONG></P> <UL> <LI>Qlik Replicate</LI> </UL> <P><STRONG>Resolution</STRONG></P> <P>The work around below converts all the string (0) to string (10 or the number you specified). It is important to specify the scope under advanced options to convert only string (0) to string (10).</P> <OL> <LI>From Global Rules window, click on “New Rule” and select Transformation.</LI> </OL> <P class="lia-indent-padding-left-30px"><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Dineshan_0-1656100465926.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/82637i794D6194764956B8/image-size/medium?v=v2&amp;px=400" role="button" title="Dineshan_0-1656100465926.png" alt="Dineshan_0-1656100465926.png" /></span></P> <P class="lia-indent-padding-left-30px"><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Dineshan_1-1656100466029.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/82638i76DE7E369F31B21C/image-size/medium?v=v2&amp;px=400" role="button" title="Dineshan_1-1656100466029.png" alt="Dineshan_1-1656100466029.png" /></span></P> <OL start="2"> <LI>Select “Convert data type” and click Next</LI> <LI>Select “STRING” in the data type dropdown. Under advanced options, enter expression “$AR_M_SOURCE_DATATYPE_LENGTH==0” without quotes and click next:</LI> </OL> <P class="lia-indent-padding-left-30px"><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Dineshan_2-1656100466064.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/82639iA6ED2A57AB5FA9A4/image-size/medium?v=v2&amp;px=400" role="button" title="Dineshan_2-1656100466064.png" alt="Dineshan_2-1656100466064.png" /></span></P> <OL start="4"> <LI>Change the length to 10 or desired number and click Finish.</LI> </OL> <P class="lia-indent-padding-left-30px"><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Dineshan_3-1656100466125.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/82640iFAC823E18EBD3724/image-size/medium?v=v2&amp;px=400" role="button" title="Dineshan_3-1656100466125.png" alt="Dineshan_3-1656100466125.png" /></span></P> <P><STRONG>Cause:</STRONG></P> <P>NULL columns are not supported and Oracle SQL views with fields defaulted to NULL explicitly, creates fields with data type string (0).</P> Fri, 24 Jun 2022 20:09:44 GMT Dineshan 2022-06-24T20:09:44Z https://community.qlik.com/t5/Official-Support-Articles/Unable-to-translate-data-type-from-Oracle-SQL-views-and-unable/ta-p/1948090 <P>Replicating data from Oracle SQL views (with few fields defaulted to NULL explicitly) into snowflake fails to create table in Snowflake.</P> <P><STRONG>Environment</STRONG></P> <UL> <LI>Qlik Replicate</LI> </UL> <P><STRONG>Resolution</STRONG></P> <P>The work around below converts all the string (0) to string (10 or the number you specified). It is important to specify the scope under advanced options to convert only string (0) to string (10).</P> <OL> <LI>From Global Rules window, click on “New Rule” and select Transformation.</LI> </OL> <P class="lia-indent-padding-left-30px"><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Dineshan_0-1656100465926.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/82637i794D6194764956B8/image-size/medium?v=v2&amp;px=400" role="button" title="Dineshan_0-1656100465926.png" alt="Dineshan_0-1656100465926.png" /></span></P> <P class="lia-indent-padding-left-30px"><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Dineshan_1-1656100466029.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/82638i76DE7E369F31B21C/image-size/medium?v=v2&amp;px=400" role="button" title="Dineshan_1-1656100466029.png" alt="Dineshan_1-1656100466029.png" /></span></P> <OL start="2"> <LI>Select “Convert data type” and click Next</LI> <LI>Select “STRING” in the data type dropdown. Under advanced options, enter expression “$AR_M_SOURCE_DATATYPE_LENGTH==0” without quotes and click next:</LI> </OL> <P class="lia-indent-padding-left-30px"><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Dineshan_2-1656100466064.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/82639iA6ED2A57AB5FA9A4/image-size/medium?v=v2&amp;px=400" role="button" title="Dineshan_2-1656100466064.png" alt="Dineshan_2-1656100466064.png" /></span></P> <OL start="4"> <LI>Change the length to 10 or desired number and click Finish.</LI> </OL> <P class="lia-indent-padding-left-30px"><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Dineshan_3-1656100466125.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/82640iFAC823E18EBD3724/image-size/medium?v=v2&amp;px=400" role="button" title="Dineshan_3-1656100466125.png" alt="Dineshan_3-1656100466125.png" /></span></P> <P><STRONG>Cause:</STRONG></P> <P>NULL columns are not supported and Oracle SQL views with fields defaulted to NULL explicitly, creates fields with data type string (0).</P> Fri, 24 Jun 2022 20:09:44 GMT https://community.qlik.com/t5/Official-Support-Articles/Unable-to-translate-data-type-from-Oracle-SQL-views-and-unable/ta-p/1948090 Dineshan 2022-06-24T20:09:44Z