Parse and Join question

[Lilydale]

Hi, need help to parse and combine the files together. Thanks 

[DawnDuong]

hi @Lilydale 

This looks like a weekly challenge / exercise from Alteryx, have you tried searching for the solution?

Also, if may be a good idea for you to make first attempt and then the community members can help where you get stuck.

Dawn.

[Lilydale]

Thanks. Made an attempt to parse the data into right format.

Can someone teach me how to use join for two of the input files ? Thanks 

[DawnDuong]

Hi @Lilydale 

You got it right to the mid-point. This exercise tests you ability to "visualise" data structure and use the Join Tool, Transpose, Crosstab and the Parse-type tools.

Sometimes it is more efficient to transpose the data to "long and thin" format before you Join them. In these circumstances, using the RecordID tool is commonly seen so that you can 'restore' the data back to the format you want.

Also, if you simply use the CrossTab Tool directly, the headers will contain the "underscore" instead of "space" between words. Thus there is a workaround solution using the Join Tool by position and the dynamic rename. 

I noticed that someone posted a question with an identical data/file a couple of days back - probably you have the same learning resources. There are likely many ways to get to the same solutions, but almost always you need to get the "core tools" solid.

Those little details behind the use of all the "core" tools actually will require a lot of practices - so: happy exploring! 

Hope this helps.
Dawn.