Alteryx Workflow Help

Question

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!

Alteryx test Transfer Pricing Review _ ROW.xlsx

Emmanuel_G · Answer

@lenguyen1994

Sorry for that! Other little modifications were needed.

Find in attachement the corrected workflow.

Hope it's ok this round.😉

Alteryx Workflow Help v3.yxmd

lenguyen1994 · Answer

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 · Answer

@lenguyen1994

Absolutely ! 🙂

Is it what you want ?

Alteryx Workflow Help v2.yxmd