Please enable JavaScript.
Coggle requires JavaScript to display documents.
Chapter 5 Cultural Musings (5.2 Allocate Input (Pick Geography (Allows…
Chapter 5 Cultural Musings
5.1 Tools & Concepts
Tools
Allocate
Input
Find Replace
Joins
Multiple
Text To
Columns
Create
Samples
Random
Sample
XML Parse
Concepts
Using Census Data
Data Mapping
Complex Joins
Splitting filed members
Splitting Data Stream
Read & Parse XML
5.2 Allocate Input
Shows us to get inpout from demographic data
Choose dataset drop down
use allocate Workspace
Workspace
Pick Geography
Allows geogrphic level
Pick Variables
Select demographic variables
Special Fields
5.3 Allocate Input
Find Replace
Allows to replace info in data
Find
Allows to find matching criteria
Replace
What replacement field is
5.4 Join Multiple
Full outer join between data streams
5.5 Text to Column
Text To Columns will break string fields
Field to Split
Allows us to select the filed to be split
Delimeters
list of special characters
Split to Column
Extra Column
of clumns
Output root name
5.6 Create Sample
Create Sample tool splits the input records into two or two three random smaples
Validation Sample Percent
allows to select percentage data in validation sample
5.7 Random % Sample
Random % Sample Macros tool returns an expected number of records resulting in a random sample of the incoming data
Allows to specify N
Random N%
Deterministic Output
5.8 XML Parse
XML parsing tool reads in XML snippets and parses them into individuals fields
XML Elements to Parse
Return Child Values
Return Outer XML
Ignore XML Errors and continue
5.9 Culturally Rich
GDP per Capita
State associated with each museum
State Map
Go through workflow