topic Re: Auto Created NULL record ID 0 is missing in referenced tables in Qlik Compose

Auto Created NULL record ID 0 is missing in referenced tables

Pierre_G — Fri, 14 Mar 2025 20:49:07 GMT

My assumption:

1. When running a Data Warehouse tasks, loading a foreign key column that has a NULL in the source is replaced with 0 and it is tied to the auto-created NULL record (ID=0) in the referenced table.

2. A NULL record with ID 0 is auto-created in the referenced table

My Problem:

When a null value is loaded in a foreign key column, it is replaced with a 0 but the corresponding referenced table does not get the auto-created NULL record (ID=0)

note1: My problem is for all foreign keys.
Note2: The foreign keys are correctly defined in the Model

Re: Auto Created NULL record ID 0 is missing in referenced tables

Adam_Herman — Mon, 12 Dec 2022 09:23:05 GMT

Hi @Pierre_G

I see that you have raised an incident for this behavior to the support team.

Please check the case, as we have asked for additional information to be provided so we can start with our investigation.

Thank you in advance for your time.

Regards,
Adam

Re: Auto Created NULL record ID 0 is missing in referenced tables

Nanda_Ravindra — Wed, 21 Dec 2022 04:06:54 GMT

@Pierre_G I worked with you on this issue on a support case and you you resolved the issue by dropping and recreating the DWH. The RCA for this issue was related to using truncate statement in your pre- etl step which is not a suggested method in DWH field.

Thanks,

Nanda