Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Restructuring a manufacturing process form

MGartlan
5 - Atom

Hi Alteryx community!

 

I am failry new to Alteryx and could use some advice. What are the best practices surrounding restructuring an input that comes to me looking like the following: 

example.PNG

 

Thanks!

- Alteryx Newbie 

3 REPLIES 3
kelsey_kincaid
12 - Quasar

Welcome! I think the answer to your question really depends - is this a one-off transformation or will it be a recurring process? If a recurring process, does the data come in the same format each time (same number of rows in each section, same header names, etc.)? What data is important to capture on this input file, and what data is okay to be dropped (if any)? What's the ideal output?

MGartlan
5 - Atom

The forms come from a recurring process and always in this format, so same headers, same number of attributes and such. The re-formatted version will be used for statistical analysis. As I mess with it more, I am inclined to drop the headers as they contain product specific information which can also be distinguished by batch. So the heart of the form lies with the attributes and data. 

kelsey_kincaid
12 - Quasar

The way I would suggest approaching this is by splitting your input data into chunks and processing each separately. Then after all processing is complete you can union it all back together. Without knowing the finer details of your data or what the output should look like, I put together this (very) rough example of what you could do. I used a few multi-field and multi-row formulas to process the data, then filtered based on 'section' in the form. From there I used Select tools to grab columns separately, standardize naming, and then union them back together. Your middle section there is a little tricky and I haven't nailed that one down yet, but hopefully what I started doing proves helpful to you in some way. My hope is that this gives you some ideas and a place to start. It's not the prettiest solution, but one thing I've learned is that if it works it works 🙂

Labels