<< Click to Display Table of Contents >> Navigation:  5. Detailed description of the Actions > 5.4. Join Tables > 5.4.4. Filter On Key (High-Speed action)

 

Icon:

 
Function: FilterOnKe
 

Property window:

 

 

Short description:

 

Filter Rows based on a set of “Reference” Keys.

 

Long Description:

 

Filter Rows based on a set of “Reference” Keys.

 

It is assumed that the column used as key inside the SLAVE tables have no duplicates (i.e. it can be used as primary key). Unexpected results may occur if that’s not the case. Anatella checks for the uniqueness of the keys in the SLAVE tables. This check might take some time and you can thus de-activate it but it’s strongly not recommended. If the check fails (i.e. if there are some duplicate keys inside one of the slave tables), you can investigate this data quality issue using the NaïveDeDuplicate Action.