topic Re: Parsing data from a single field into a formatted table. in Alteryx Designer Desktop Discussions

Parsing data from a single field into a formatted table.

Fernandez — Tue, 11 Jan 2022 10:24:18 GMT

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

atcodedog05 — Tue, 11 Jan 2022 10:30:59 GMT

Here is how you can do it.

Workflow:

Hope this helps : )

Fernandez — Tue, 11 Jan 2022 10:35:15 GMT

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 — Tue, 11 Jan 2022 10:40:17 GMT

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 — Tue, 11 Jan 2022 11:01:10 GMT

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 — Tue, 11 Jan 2022 13:07:55 GMT

Happy to help : ) @Fernandez

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

Cheers and have a nice day!