Retrieve leads from an External Data source
Table( (TagValueSelection( External Source ID, Syntax Component, Component Value ) ), [Table Level] )
- External Source ID defines the ID of the External Data source to which the TagValueSelection is applied
- Syntax Component defines the type of records to retrieve, see below for components
- Component Value defines the value which the Syntax Component uses to assess the records within the model
- Table Level selects the level to which data is rolled, e.g. individual, household, etc.
| Component | Description |
|---|---|
| TakeFirst | Retrieves the first/top n records where n=Component Value |
| TakeOver | Retrieves records that have a value over n where n=Component Value |
| TakeUnder | Retrieves records that have a value under n where n=Component Value |
Example: Retrieve the top 500 individuals from External Data source 195
Table( ( TagValueSelection( 195, TakeFirst, 500 ) ), [Individual] )