Hi everyone,
I've been tasked with transforming the output of a lengthy skills matrix related Google form. A chunk of the survey invites respondents to select which skills they would like to learn more about.
The Google form / survey is set up in a tick/select box format and when I extract the data, it looks like this:
| Name | Skill |
| Colleague A | Alteryx, Power BI, Tableau |
| Colleague B | Use Case Modelling, RAIDD Management - Risks, Assumptions, Issues, Dependencies, Decisions raising and logging, Robotic Process Automation |
| Colleague C | Python - Programming, Microsoft Cloud |
My workflow currently includes Transpose and Text to Columns (configured to split to rows and ',' delimiter) tools to transform this data and whereas the majority of the data set looks good, I'm encountering a limitation with Colleague B's responses as my data, following parsing and renaming columns with a Select tool, now looks like this:
| Name | Skills colleague would like to learn more about |
| Colleague A | Alteryx |
| Colleague A | Power BI |
| Colleague A | Tableau |
| Colleague B | Use Case Modelling |
| Colleague B | RAIDD Management - Risks |
| Colleague B | Assumptions |
| Colleague B | Issues |
| Colleague B | Dependencies |
| Colleague B | Decisions raising and logging |
| Colleague B | Robotic Process Automation |
| Colleague C | Python - Programming |
| Colleague C | Microsoft Cloud |
As you can see, there is a limitation to my workflow setup currently, as the 'RAID - Management - Risks, Assumptions, Issues, Dependencies, Decisions raising and logging' response has been parsed when I don't want it to be. My current configuration is not accounting for this response, and these other selections:
| Skills |
| RAIDD Management - Risks, Assumptions, Issues, Dependencies, Decisions raising and logging |
| Configuration Management - Documentation, Version Control, Trackers and Recordkeeping mechanisms |
| Requirements Management: Elicitation, Engineering, Inventory and Change Requirements |
| Epic, Features, Themes and Story Approach |
| Google suite - Sheets, Docs, Presentation, GDrive |
| SAP - Systems, Applications, and Products |
Can anyone help suggest how I may overcome this? Is there a sophisticated Formula tool that may be needed?
Many thanks,
KA
