Challenge #50: Preparing Survey Data
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
SeanAdams
17 - Castor
05-04-2017
10:52 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks @JoeM - I'll make sure to get my hair cut that week so that if I can't win by brain-power (especially given the competition from @estherb47; @NicoleJohnson; @MarqueeCrew ) - at least I can try to win the "best haircut" runner-up prize.
LordNeilLord
15 - Aurora
06-01-2017
05:33 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
nick_ceneviva
11 - Bolide
08-16-2017
12:11 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Solution Attached
Spoiler
I used a little bit of a different approach. I used two different dynamic rename tools. The first one changes the column names from the Data input file to be just the column number (ie. F1 -> 1). The second dynamic rename uses the "Take Field Names from Right Input Tool" setting and matches on the column field from the question file and renames the fields as the Text label.
The select tool is used to filter out the other questions and to rename the respondentID, Date and Time fields. Finally the Age and response are parsed from the one column.
The select tool is used to filter out the other questions and to rename the respondentID, Date and Time fields. Finally the Age and response are parsed from the one column.
.
patrick_digan
17 - Castor
09-22-2017
08:50 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Natasha
9 - Comet
11-04-2017
04:23 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
samN
10 - Fireball
12-05-2017
06:03 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
ggruccio
ACE Emeritus
12-11-2017
05:11 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
LandonG
8 - Asteroid
12-13-2017
06:37 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
PhilipMannering
16 - Nebula
12-16-2017
03:39 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
jasperlch
12 - Quasar
12-17-2017
01:43 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator