5.4.4. Filter On Key (High-Speed clip0090 action)

<< 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 clip0090 action)

 

Icon: ANATEL~3_img115

 

Function: FilterOnKey
 
Property window:

 

ANATEL~3_img263

 

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 clip0112 NaïveDeDuplicate Action.