Using Multi Row/Multi Field Formula to resolve the issue

Hello Team,

Please help me to resolve the difficulties which I am facing in one of my delivery where I need to use Multi Row/Multi Field formula to get the result, I am stucked to move forward, Please help me, Thanks in advance.

Any help would be appreciated.

Thanks

AJAY

Transformation

Preparation

Text Mining

Accepted answers

If you want to know more about how to use the multi-row formula I suggest the following help article:

https://help.alteryx.com/20223/designer/multi-row-formula-tool

I would also strongly recommend jumping in to the Learning Paths section of the Alteryx Academy:

https://community.alteryx.com/t5/Learning-Paths/Getting-Started-Learning-Path/ta-p/475117

You can also try the interactive lessons which has a specific one for multi-row formula:

https://community.alteryx.com/t5/Interactive-Lessons/Multi-Row-Formula/ta-p/82872#done

Once you have gone through these, and are still unable to build this then I suggest you reach out with the specific problem you are having.

Thanks,

M.

All comments

If you want to know more about how to use the multi-row formula I suggest the following help article:

https://help.alteryx.com/20223/designer/multi-row-formula-tool

I would also strongly recommend jumping in to the Learning Paths section of the Alteryx Academy:

https://community.alteryx.com/t5/Learning-Paths/Getting-Started-Learning-Path/ta-p/475117

You can also try the interactive lessons which has a specific one for multi-row formula:

https://community.alteryx.com/t5/Interactive-Lessons/Multi-Row-Formula/ta-p/82872#done

Once you have gone through these, and are still unable to build this then I suggest you reach out with the specific problem you are having.

Thanks,

M.

Please find the expected output.

K4 = (J4-K3)+K2

Many thanks

Shanker V

Step 1: Input

Step 2:

Step 3:

Many thanks

Shanker V

Step 4: Sort tool

Step 5:

IF [F11]="Inventory: 4PL"
THEN tonumber([Row-4:Value])-tonumber([Row-2:Value])+tonumber([Row-1:Value])
ELSE [Value]
ENDIF

Step 6:

Many thanks

Shanker V

Here is a way to replicate your output:

Calculate Inventory.yxmd

Adding the dynamic tool at the end will help the column name to take from the first row.

This is optional based on how you need to format the output.

Many thanks

Shanker V

Hello Shanker,

Would you not mind to attach the workflow here.

Thanks

AJAY

Hello Finn,

In this case your solution doesn't work for me if my dataset changes, It works for that particular data which was provided earlier, Have a look by attaching my new dataset with the same solution provided by you. Any help would be highly appreciated.

Thanks

AJAY

Dataset_New.xlsx

Can you please share the formula to be applied for the new dataset.

Many thanks

Shanker V

Hello Shanker,

Thanks for understanding, I am attaching the file wherein Output sheet contains the dynamic formula for INVENTORY: 4PL row,

In real time there would be 100 number of SKUs, please have a look into the formula and let me know if you need anything in detail.

Thanks

AJAY

Dataset_New.xlsx

Please find the expected output.

The workflow is changed dynamically to work even if more rows are added to the dataset.

Many thanks

Shanker V

Final one Using Multi Row Multi Field Formula to resolve the issue.yxmd

Hi Shanker,

I see the solution with exact output I was looking for but is there any specific reason you are always considering the first row as contains data, Just curious to know.

Without that can we solve this.

Thanks

AJAY

I just tried to do the things by keeping first row as header, Some minor issue not able to figure out, Please help me to identify, I am attaching my Workflow here for your reference.

I really appreciate your help and support which is having a huge impact on my career for sure, May god bless you.

Thanks

AJAY

Ajay_Dynamic.yxmd

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703