Input5
I
M
M
F
S
F
D
Output20
Find and Replace Values (via Join) with Standard Responses
Warn
Select as Data Fields those columns that will need to be replaced with standard values
Gender
M
Male
Gender
F
Female
Marriage Status
M
Married
Marriage Status
S
Single
Marriage Status
D
Divorced
Gender
1
Male
Gender
2
Female
Gender
Child
Undefined
Text Input with List of all Field Replacement Scenarios (include standardized column name as well as Old and New values)
Join on Name and Value, keeping New Value Field
Warning
All
ByName
Union Results
,
Group by all fields except Name and Value. Name = Headers, Value = Values
Rename Columns to Standard Format
Sex
Gender
M/F
Gender
Status
Marriage Status
Married
Marriage Status
Text Input with List of all Column Rename Scenarios
RightInputRows
Warn
Mapped
OldTitle
NewTitle
Dynamic Rename - Take Field Names from Right Input Rows
RecordID
1
Int32
6
0
Adding RecordID as unique record identifier for use in Transpose/Cross-Tab
Horizontal
Question
Macro Input (5)
Question
Macro Output (20)
New Workflow2
Tab
Questions
Tab (4)
MacroInput
Macro Input (5)
Macro Input (5)
MacroOutput
Macro Output (20)
Macro Output (20)
Macro