Alteryx Workflow Help

[lenguyen1994]

Hi,

I have the Input data attached and looking for help on an Alteryx workflow that work horizontally. Basically, I need to pull info and calculate based on data above row 240. And with the result, I need to determine either it is within or out of a predetermined range. Could anyone please help me with this? Thank you!

[Emmanuel_G]

@lenguyen1994 

Find in attachement the way of creating these two rows at the end of file.

Let me know if it works as you want or not.😉

[lenguyen1994]

Hi Emmanuel, thanks so much! Do you mind if I ask for the output, is there anyway we could only print the Row 212 ,Row 26, the preset standage range and results?

[Emmanuel_G]

@lenguyen1994 

Absolutely ! 🙂

Is it what you want ?

[lenguyen1994]

Hi @Emmanuel, thank you this is exactly what I was looking. I just have a question for my own understanding, is there a reason that column starts with F1,F2 etc and not the Sub 1 Sub 2 Sub3? Is there anyway I could change for the data to start on row 6? When i did this it seems to cause an error.

[Emmanuel_G]

@lenguyen1994 

Sorry for that! Other little modifications were needed.

Find in attachement the corrected workflow.

Hope it's ok this round.😉