Parsing data from a single field into a formatted table.

Question

Hi Team, Can I have help please to resolve this challenge?

The data contained in the field "Data" needs to be parsed effectively for analysis.

Thanks

DataPrep_QualtricsSurveyParsing (1).yxmd

atcodedog05 · Accepted Answer

Hi @Fernandez

Here is how you can do it.

Workflow:

Hope this helps : )

Fernandez · Accepted Answer

Hi atcodedog05

Many thanks for your reply and help.

On the exercise it mention that only 'Tools to Investigate: Text to Columns, Sample, Dynamic Rename'

Is OK/allow to use more tools to resolve this challenge?

atcodedog05 · Accepted Answer

Hi @Fernandez

You can achieve it with only 'Text to Columns, Sample, Dynamic Rename' tools to

Is this an Alteryx Community learning path challenge? can you provide more info on this task.

Workflow:

Hope this helps : )

Fernandez · Accepted Answer

Hi atcodedog05,

Awesome! The exercise is focus in reshape the data from the Text Input tool and parse into a table.

Thanks a lot

atcodedog05 · Accepted Answer

Happy to help : ) @Fernandez

If my response helps please don't forget to mark it as solution.

Cheers and have a nice day!