Multi Row or Multi Field Tool Configuration Challenge

Hello Team,

Need some quick help for Getting one row value by adding another 2 rows value, Not sure which one needs to be used, Like Multi row or multi field, I am attaching my problem statement here, Please let me know the right approach, Many thanks in advance.

Thanks

AJAY

InputData.xlsx

Transformation

Preparation

Text Mining

Accepted answers

ShankerV

Hi @ajanayak

Please make use of the multi row formula to get the desired output.

Edit: Before use the Transpose tool.

BS_THE_ANALYST

@ajanayak I've attached a workflow which applies the type of data manipulation + multirow formula I described above. Although, the Multi Row tool will need to be configured to suit your needs

23012023multirowhelp1.yxzp

ShankerV

Hi @ajanayak

Thanks for your reply. Glad that my solution worked.

But I noticed your data heading has M-1 and M+5 etc

Those are replaced as below,

To over come that, I have used the dynamic rename in my solution.

If you need the column names to remain same like below,

The solution attached will help you.

Many thanks

Shanker V

Multi Row or Multi Field Tool Configuration Challenge.yxmd

All comments

ShankerV

Hi @ajanayak

Please make use of the multi row formula to get the desired output.

Edit: Before use the Transpose tool.

BS_THE_ANALYST

@ajanayak You will need to use the Multi Row tool to achieve your result. But this will only apply to ONE column. In order to apply that Multi Row tool across multiple columns you can do two things (I can think of):

1. Apply the Multi Row tool to each of the columns you want to use it on. This could be annoying though as you have lots of columns you want to use it on!

2. (the better way) you will need to manipulate your data so you will only need to apply the Multi Row tool once.

BS_THE_ANALYST

@ajanayak I've attached a workflow which applies the type of data manipulation + multirow formula I described above. Although, the Multi Row tool will need to be configured to suit your needs