This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.
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.
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.