https://community.qlik.com/t5/Qlik-Compose/Issue-with-Unsupported-varchar-Data-Type-in-Qlik-Compose/m-p/2112511#M1105 <P>Hello&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/192894">@jessica_molinacalabrese</a>&nbsp;<BR /><BR /></P> <P><SPAN>Its limitation column with datatype VARCHAR(MAX) is not supported in Compose.<BR /><BR /></SPAN></P> <P><SPAN>Could you please try below workaround</SPAN></P> <P>Run Replicate with a metadata run and let the table(s) get created.&nbsp;</P> <P>Change the nvarchar(max) columns to varcahr(8000) on the target.</P> <P>Make sure task is set to truncate on full load and 'Delete old changes and store changes in existing change table' for change tables.</P> <P>Start the task.</P> <P>Check collum(s) appear in the compose table creation.</P> <P>Let us know how it goes.</P> <P>&nbsp;</P> <P>Regards,</P> <P>Suresh</P> Sat, 02 Sep 2023 12:10:57 GMT sureshkumar 2023-09-02T12:10:57Z https://community.qlik.com/t5/Qlik-Compose/Issue-with-Unsupported-varchar-Data-Type-in-Qlik-Compose/m-p/2111650#M1103 <DIV class="flex-1 overflow-hidden"> <DIV class="react-scroll-to-bottom--css-bsbkr-79elbk h-full dark:bg-gray-800"> <DIV class="react-scroll-to-bottom--css-bsbkr-1n7m0yu"> <DIV class="flex flex-col text-sm dark:bg-gray-800"> <DIV class="group w-full text-token-text-primary border-b border-black/10 dark:border-gray-900/50 bg-gray-50 dark:bg-[#444654]" data-testid="conversation-turn-17"> <DIV class="p-4 justify-center text-base md:gap-6 md:py-6 lg:px-0 m-auto"> <DIV class="flex flex-1 gap-4 text-base mx-auto md:gap-6 md:max-w-2xl lg:max-w-[38rem] xl:max-w-3xl }"> <DIV class="relative flex w-[calc(100%-50px)] flex-col gap-1 md:gap-3 lg:w-[calc(100%-115px)]"> <DIV class="flex flex-grow flex-col gap-3 max-w-full"> <DIV class="min-h-[20px] flex flex-col items-start gap-3 overflow-x-auto whitespace-pre-wrap break-words"> <DIV class="markdown prose w-full break-words dark:prose-invert light"> <P>Hi,</P> <P>I am writing to report an issue I've encountered regarding Qlik Compose's compatibility with certain varchar data types in tables when the length of the varchar is not defined. After analyzing the table metadata, I've observed that when the fields <CODE>CHARACTER_MAXIMUM_LENGTH</CODE> and <CODE>CHARACTER_OCTET_LENGTH</CODE> are set to -1 (as seen in the attached image), Compose seems to struggle with loading that particular column.</P> <P>I'd like to provide some context and details about the situation:</P> <OL> <LI> <P><STRONG>Background</STRONG>: My data source is Azure, and the data warehouse project in Compose is connected to a Microsoft SQL Server.</P> </LI> <LI> <P><STRONG>Scenario</STRONG>: The issue arises when the varchar data type is either not defined due to table creation through a query (such as "SELECT * INTO...") or when it is defined as varchar(MAX).</P> </LI> <LI> <P><STRONG>Observation</STRONG>: Upon investigating, I found that Qlik Compose encounters difficulties when loading tables with varchar columns exhibiting the characteristics mentioned above.</P> </LI> </OL> <P>Considering the circumstances, I have a few questions:</P> <UL> <LI>Is this limitation a known behavior of Qlik Compose?</LI> <LI>Are there any workarounds or solutions you can suggest to overcome this issue?</LI> </UL> <P>I appreciate your assistance and guidance in resolving this matter. If you require any further information or context, please don't hesitate to reach out.</P> <P>Thank you for your attention to this matter. I look forward to your response.</P> <P>Best regards,&nbsp;</P> <P>Jessica.</P> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> <DIV class="absolute bottom-0 left-0 w-full border-t md:border-t-0 dark:border-white/20 md:border-transparent md:dark:border-transparent md:bg-vert-light-gradient bg-white dark:bg-gray-800 md:!bg-transparent dark:md:bg-vert-dark-gradient pt-2 md:pl-2 md:w-[calc(100%-.5rem)]"><FORM class="stretch mx-2 flex flex-row gap-3 last:mb-2 md:mx-4 md:last:mb-6 lg:mx-auto lg:max-w-2xl xl:max-w-3xl"> <DIV class="relative flex h-full flex-1 items-stretch md:flex-col"> <DIV class="flex w-full items-center">&nbsp;</DIV> </DIV> </FORM></DIV> Fri, 14 Mar 2025 20:49:07 GMT https://community.qlik.com/t5/Qlik-Compose/Issue-with-Unsupported-varchar-Data-Type-in-Qlik-Compose/m-p/2111650#M1103 jessica_molinacalabrese 2025-03-14T20:49:07Z https://community.qlik.com/t5/Qlik-Compose/Issue-with-Unsupported-varchar-Data-Type-in-Qlik-Compose/m-p/2112511#M1105 <P>Hello&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/192894">@jessica_molinacalabrese</a>&nbsp;<BR /><BR /></P> <P><SPAN>Its limitation column with datatype VARCHAR(MAX) is not supported in Compose.<BR /><BR /></SPAN></P> <P><SPAN>Could you please try below workaround</SPAN></P> <P>Run Replicate with a metadata run and let the table(s) get created.&nbsp;</P> <P>Change the nvarchar(max) columns to varcahr(8000) on the target.</P> <P>Make sure task is set to truncate on full load and 'Delete old changes and store changes in existing change table' for change tables.</P> <P>Start the task.</P> <P>Check collum(s) appear in the compose table creation.</P> <P>Let us know how it goes.</P> <P>&nbsp;</P> <P>Regards,</P> <P>Suresh</P> Sat, 02 Sep 2023 12:10:57 GMT https://community.qlik.com/t5/Qlik-Compose/Issue-with-Unsupported-varchar-Data-Type-in-Qlik-Compose/m-p/2112511#M1105 sureshkumar 2023-09-02T12:10:57Z https://community.qlik.com/t5/Qlik-Compose/Issue-with-Unsupported-varchar-Data-Type-in-Qlik-Compose/m-p/2132444#M1163 <P>I understand that sql is lacking an identical operator and is using the equal operator very opportunistically. Magic conversions of data types is one thing but just throwing away certain values in a string column is different. Even more so when the actual input is an integer. I wonder how many characters can be added in order to have it fail …</P> Fri, 27 Oct 2023 10:41:05 GMT https://community.qlik.com/t5/Qlik-Compose/Issue-with-Unsupported-varchar-Data-Type-in-Qlik-Compose/m-p/2132444#M1163 narmad78 2023-10-27T10:41:05Z