Hi Community,
I desperately need help on knowing how to convert from 'Image 1' to 'Image 2'
I basically want the Pizza, Taco, Coke, and Fries sorted by Code. But the Code will repeat itself until all the values for the foodies are filled in.
Thank you for your effort in advance.
I am attaching an example model.
Solved! Go to Solution.
Hi MarqueeCrew,
I want the groups to be dynamic, but that would be the next step since the data quality is not great right now.
And there are about.. 20-30 sets.
Hi Mark,
I am a beginner so I am having trouble fully understanding your solution.
Could you make a alteryx model and share by replying?
Thank you.
This post was interesting as it took me a few tries to solve. At first, I started down the path of simply transposing the columns and parsing the text from the number like @MarqueeCrew had mentioned, and was going to crosstab from there as @danrh showed in his solution. However, in the desired output it was the number of food types that dictates the number of rows per code, not the numeric digit from the original column name. The workflow below should accomplish this. Thanks,
jm
Hi John,
I appreciate you going through the problem with us but I wasn't able to open your file because it was created with a newer version.
I have v11.5.1.31573.
Could you please downgrade your file and repost?
Much appreciated in advance!
@see-seo See if this works for you. I just opened the file in notepad++ and replaced 11.7 with 11.5 in the xml. That should work, but let me know if it doesn't. Thanks,
jm
Hi John,
Thank you so much for going through the trouble, but could you try replacing to 11.3 instead?
I still get the same error message, but changing to 11.3 would work based on this link:
Thank You!