How to filter with a different table

[Ole_Dufour]

Using Enterprise Manager I'm looking to replicate my address table. But only addresses of active persons should be replicated.
Address.PersonId  references Person.Id so I suppose that I should use some SQL and then only select addresses whose  Person.Active = "true".

In what menu do I apply this filter and what would be its syntax?

[OritA · Accepted solution]

Hi, 

First, in general, to achieve what you want you should look at the Replicate users guide under:
'Defining transformations for a single table/view':

https://help.qlik.com/en-US/replicate/May2023/Content/Global_Common/Content/SharedEMReplicate/Custom...

You will have to first perform source_lookup for the Address.PersonId in the table persson based on the key person.id and get the value of  Person.Active and keep it in a column. and then you will be able to define a filter to filter the rows based on the value of the new column you have created that includes the content of Person.Active.

Regards,

Orit

[Ole_Dufour]

OK thanks a lot.

[Dana_Baldwin]

Hi @Ole_Dufour 

If one of the replies helped to resolve the issue, please mark it as a solution & like it to make it easier for others to find.
Thanks in advance!