New to Alteryx Designer

Hey @Inactive User.

Heres an example workflow:

Quite a bit to do as a lot of the data is contained within one cell. Please ask if any questions.

HTH,

Ira

Hey @Inactive User,

I've updated the workflow to keep the ordering correctly hopefully no other glitches.

I think its fine to continue on questions if its still on the same topic/problem, don't think there is any rules on it ether lol . Some people like to give multiple solution ticks to the follow up answers which I think is quite good.

All comments

Hey @Inactive User,

Can you show an example of how your two inputs are formatted? your second input sounds like it has all the desired information for your desired output?

Does this help?

Thanks yeah that helps I'll put something together with that though copy and pasted tables are easier as I cant copy your table from an image

Hey @Inactive User.

Heres an example workflow:

Quite a bit to do as a lot of the data is contained within one cell. Please ask if any questions.

HTH,

Ira

Thank you so much! Two follow-up questions, if you don't mind -- (1) my numbers are decimals; how would I alter the RegEx expression to account for a decimal numbers like 2.1 ? (2) what purpose does the Formula early on in the workflow with Empty = Null () serve? Thanks again!

No worries @Inactive User! glad it worked for you for the decimals I've updated the regex in the attached workflow here, let me know if you have any issues there. The formula is because you need a values column if you want to use the cross tab tool.

Thank you. One glitch I discovered in the workflow is that the Cross Tab step automatically alphabetizes the names, which then makes the Output wrong during the Union step. It looks like putting things alphabetical is built-in to Cross Tab with no way to change it. Any tips or tricks to fix?

Also, for my own awareness (since I'm new to the Community) is it ok to ask follow-on questions like this in the original thread or should I create a new question? Thanks again for your help!

Hey @Inactive User,

I've updated the workflow to keep the ordering correctly hopefully no other glitches.

Thank you for the assistance. It seems like it would be handy if Cross Tab had a setting to turn off alphabetizing when desired. In the meantime, now I know how to get around it. Thanks again!