Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
JacobTews
Creator
Creator

Lookup values not populating?

Hi, all!

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.

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:

JacobTews_0-1708713685161.png

Compose even sees it when I preview the lookup:

 

JacobTews_4-1708713895765.png

JacobTews_1-1708713731560.png

 

But after running the data load task, the values are still missing:

JacobTews_2-1708713824056.png

 

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.

Labels (3)
1 Reply
sureshkumar
Support
Support

Hello @JacobTews 

Please check below point as mentioned in the user guide

"Using lookup tables that do not have a task for CDC mapping"
Using lookup tables #Using lookup tables | Qlik Compose Help

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.

 

Regards,

Suresh