This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
admin:features:segments:creating [2012/03/05 20:57] doc |
admin:features:segments:creating [2016/06/28 22:38] (current) |
||
|---|---|---|---|
| Line 9: | Line 9: | ||
| [[admin:features:segments:home|Overview]] | | [[admin:features:segments:home|Overview]] | | ||
| **[[admin:features:segments:creating|Creating Segments]]** | | **[[admin:features:segments:creating|Creating Segments]]** | | ||
| - | [[admin:features:segments:queries|Querying Segments]] | | + | [[admin:features:segments:querying|Querying Segments]] | |
| [[admin:features:segments:dropping|Dropping Segments]] | [[admin:features:segments:dropping|Dropping Segments]] | ||
| ---- | ---- | ||
| Line 23: | Line 23: | ||
| >> from INDIVIDUALS | >> from INDIVIDUALS | ||
| >> join HOUSEHOLDS on INDIVIDUALS.HOUSEHOLD = HOUSEHOLDS.HOUSEHOLD | >> join HOUSEHOLDS on INDIVIDUALS.HOUSEHOLD = HOUSEHOLDS.HOUSEHOLD | ||
| - | |||
| >> where STATE = 'CO' and | >> where STATE = 'CO' and | ||
| - | >> CITY = 'Denver') | + | >> CITY = 'Denver'); |
| - | >> with delete; | + | |
| Segment PART_1 created with 37 rows | Segment PART_1 created with 37 rows | ||
| Line 35: | Line 33: | ||
| >> join HOUSEHOLDS on INDIVIDUALS.HOUSEHOLD = HOUSEHOLDS.HOUSEHOLD | >> join HOUSEHOLDS on INDIVIDUALS.HOUSEHOLD = HOUSEHOLDS.HOUSEHOLD | ||
| >> where STATE = 'AZ' and | >> where STATE = 'AZ' and | ||
| - | >> CITY = 'Phoenix') | + | >> CITY = 'Phoenix'); |
| - | >> with delete; | + | |
| Segment PART_2 created with 27 rows | Segment PART_2 created with 27 rows | ||
| - | > ; Create segment for Individuals born since 1980; | + | > ; Create segment for Individuals born since 1990; |
| > create segment PART_3 | > create segment PART_3 | ||
| >> as (select INDIVIDUALS.$UNIQUEKEY | >> as (select INDIVIDUALS.$UNIQUEKEY | ||
| >> from INDIVIDUALS | >> from INDIVIDUALS | ||
| - | >> where BIRTHDATE >= 'January 1, 1980') | + | >> where BIRTHDATE >= 'January 1, 1990'); |
| - | >> with delete; | + | Segment PART_3 created with 1,198 rows |
| - | Segment PART_3 created with 1,882 rows | + | |
| </code> | </code> | ||
| ==== ==== | ==== ==== | ||
| + | **[[admin:features:segments:home|Prev]]** | | ||
| **[[admin:features:segments:querying|Next]]** | **[[admin:features:segments:querying|Next]]** | ||