The Filter Configuration implements filter conditions for a specific load process step.
For information of the ExMeX Framework on this topic look here: https://tedamoh.com/de/helpdesk/doc-faq/exmex-framework-book/data-logistic/how-to-do/filtering
If you want to set a filter on a table to reduce the amount of data load, you can do this with the feature "Filter Configuration" of the companion app. Open the feature by clicking the card on the dashboard.
There are several steps you have to do now:
- Select a model
- Select an entity
- Select an attribute
After choosing these parameters from the possible list of models, entities and attributes, the Source attribute datatype is shown.
Now you can set one or two filter conditions on the selected attribute. Many options and combinations to filter are possible.
After implementing your filter condition click on the "Save" Button. The filter condition is saved on the connected database and the technical condition will be shown in the result field near the save button.
Warning: every combination of filter conditions is available for you, so you have to check the resulting filter condition yourself. Be aware to choose the correct filter to have your desired data flow.
A filter could exlude all data completely (e.g. [LieferantNummer] >= 1500 AND [LieferantNummer] <= 1200 )
Or a filter may contradict itself (e.g. [LieferantLand] = 'GER' AND [LieferantLand] NOT IN ('GB','USA','GER','ISL') )