Compose does not update relationship

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

Hi all,

we have an Entity (Student Master Data) which has two relationships: the first one is towards the Country Master Data, the other is towards the Municipality Master Data.

The relationships have been added in different times during developent.

When we check the data, we found that the municipality ID has not been updated for some records.

We tried to investigate and found out that the TSTG_<TABLE>_P performs an inner join on the Country and Muncipality tables, but for these records the Country has a null value, so the record is not inserted in the TSTG_<TABLE>_P and the other relationship (which has values) is not correctly populated.

How can we workaround this? We do not want to truncate the HUB table.

Thank you

Michela

Re: Compose does not update relationship

Adam_Herman — Mon, 08 May 2023 09:16:33 GMT

Hi @michelabarsottini

I have received your case in our support portal, and will continue working there.

As this scenario, requires additional details to be provided for analysis purposes.

Regards,

Adam

topic Compose does not update relationship in Qlik Compose

Compose does not update relationship

Re: Compose does not update relationship