https://community.qlik.com/t5/Qlik-Compose/Lookup-values-not-populating/m-p/2423828#M1287 <P>Hello&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/223649">@JacobTews</a>&nbsp;<BR /><BR /></P> <P>Please check below point as mentioned in the user guide</P> <P><SPAN><SPAN class="ui-provider a b c d e f g h i j k l m n o p q r s t u v w x y z ab ac ae af ag ah ai aj ak"><STRONG>"Using lookup tables that do not have a task for CDC mapping"<BR /><A href="https://help.qlik.com/en-US/compose/November2023/Content/ComposeDWDL/Main/DW/Data%20Warehouse/use_lookup_tables.htm#ar_dwh_3072340365_1851879" target="_blank">Using lookup tables #Using lookup tables | Qlik Compose Help</A><BR /></STRONG></SPAN></SPAN></P> <P><SPAN class="ui-provider a b c d e f g h i j k l m n o p q r s t u v w x y z ab ac ae af ag ah ai aj ak">If the issue is not related to the above point then i would request you to open a case by atatching all the details along with Diagnostic Package.</SPAN></P> <P>&nbsp;</P> <P><SPAN class="ui-provider a b c d e f g h i j k l m n o p q r s t u v w x y z ab ac ae af ag ah ai aj ak">Regards,</SPAN></P> <P><SPAN class="ui-provider a b c d e f g h i j k l m n o p q r s t u v w x y z ab ac ae af ag ah ai aj ak">Suresh</SPAN></P> Tue, 27 Feb 2024 03:03:36 GMT sureshkumar 2024-02-27T03:03:36Z https://community.qlik.com/t5/Qlik-Compose/Lookup-values-not-populating/m-p/2423074#M1286 <P>Hi, all!</P> <P>I have a lookup table which is used to populate two columns in my CustomerShipAddress table (latitude and longitude). Up until a few weeks ago, it seemed to work fine; the script to geocode new addresses was run weekly and we hadn't encountered any issues.</P> <P>Now it doesn't appear to write the values when running the CDC task. For this customer, the correct lat-lon exists in the lookup table:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="JacobTews_0-1708713685161.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/160583iAD49D7414892D897/image-size/medium?v=v2&amp;px=400" role="button" title="JacobTews_0-1708713685161.png" alt="JacobTews_0-1708713685161.png" /></span></P> <P>Compose even sees it when I preview the lookup:</P> <DIV id="tinyMceEditorJacobTews_3" class="mceNonEditable lia-copypaste-placeholder">&nbsp;</DIV> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="JacobTews_4-1708713895765.png" style="width: 200px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/160587iE5149C0832E7429B/image-size/small?v=v2&amp;px=200" role="button" title="JacobTews_4-1708713895765.png" alt="JacobTews_4-1708713895765.png" /></span></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="JacobTews_1-1708713731560.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/160584iF2282AF9F2344341/image-size/medium?v=v2&amp;px=400" role="button" title="JacobTews_1-1708713731560.png" alt="JacobTews_1-1708713731560.png" /></span></P> <P>&nbsp;</P> <P>But after running the data load task, the values are still missing:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="JacobTews_2-1708713824056.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/160585i2F45BCC10775187A/image-size/medium?v=v2&amp;px=400" role="button" title="JacobTews_2-1708713824056.png" alt="JacobTews_2-1708713824056.png" /></span></P> <P>&nbsp;</P> <P>Anyone dealt with this before? I was able to get the values pushed through by running a full load, but I'm not sure why that would be the case now when it wasn't before.</P> Fri, 14 Mar 2025 20:49:07 GMT https://community.qlik.com/t5/Qlik-Compose/Lookup-values-not-populating/m-p/2423074#M1286 JacobTews 2025-03-14T20:49:07Z https://community.qlik.com/t5/Qlik-Compose/Lookup-values-not-populating/m-p/2423828#M1287 <P>Hello&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/223649">@JacobTews</a>&nbsp;<BR /><BR /></P> <P>Please check below point as mentioned in the user guide</P> <P><SPAN><SPAN class="ui-provider a b c d e f g h i j k l m n o p q r s t u v w x y z ab ac ae af ag ah ai aj ak"><STRONG>"Using lookup tables that do not have a task for CDC mapping"<BR /><A href="https://help.qlik.com/en-US/compose/November2023/Content/ComposeDWDL/Main/DW/Data%20Warehouse/use_lookup_tables.htm#ar_dwh_3072340365_1851879" target="_blank">Using lookup tables #Using lookup tables | Qlik Compose Help</A><BR /></STRONG></SPAN></SPAN></P> <P><SPAN class="ui-provider a b c d e f g h i j k l m n o p q r s t u v w x y z ab ac ae af ag ah ai aj ak">If the issue is not related to the above point then i would request you to open a case by atatching all the details along with Diagnostic Package.</SPAN></P> <P>&nbsp;</P> <P><SPAN class="ui-provider a b c d e f g h i j k l m n o p q r s t u v w x y z ab ac ae af ag ah ai aj ak">Regards,</SPAN></P> <P><SPAN class="ui-provider a b c d e f g h i j k l m n o p q r s t u v w x y z ab ac ae af ag ah ai aj ak">Suresh</SPAN></P> Tue, 27 Feb 2024 03:03:36 GMT https://community.qlik.com/t5/Qlik-Compose/Lookup-values-not-populating/m-p/2423828#M1287 sureshkumar 2024-02-27T03:03:36Z