Parsing data from a single field into a formatted table.

[Fernandez]

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 · Accepted solution]

Hi @Fernandez 

Here is how you can do it.

Workflow:

Hope this helps : )

[Fernandez · Accepted solution]

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 solution]

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 solution]

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 solution]

Happy to help : ) @Fernandez 

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

Cheers and have a nice day!