How to filter data?
User Defined Filters can be uploaded to the Manage Mapping Files section of the application. There two types of filters, those that filter columns in a data set and those that filter rows.
User Defined Filters can be uploaded to the Manage Mapping Files section of the application. There two types of filters, those that filter columns in a data set and those that filter rows.
Filter Columns: Create A Single Row Text File Contain the name of the columns you want to include, the keyword @COLUMN REDUCE must be included on the first line of the file to tell the application what sort of file it is.
Filter Columns: Create A Single Row Text File Contain the name of the columns you want to include, the keyword @COLUMN REDUCE must be included on the first line of the file to tell the application what sort of file it is.
Filter Rows: Create a text file containing a single column and multiple rows. Column heading is the name of the field to filter the main data set on. Each row contains the values to keep. Keywords @ANY, @EMPTY, @NON ZERO can be used to filter in any row with any value (non-null), empty value, or a non-zero value for this column.
Filter Rows: Create a text file containing a single column and multiple rows. Column heading is the name of the field to filter the main data set on. Each row contains the values to keep. Keywords @ANY, @EMPTY, @NON ZERO can be used to filter in any row with any value (non-null), empty value, or a non-zero value for this column.
Filters are applied when importing data, processing data, calculating price elasticities.
Filters are applied when importing data, processing data, calculating price elasticities.