Multi Row or Multi Field Tool Configuration Challenge

[ajanayak]

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

[ShankerV · Accepted solution]

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 · Accepted solution]

@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

[ShankerV]

Hi @ajanayak 

Please find the expected output.

Many thanks

Shanker V

[ajanayak]

Hello Shanker,

You are awesome, I did it by taking the help of your approach, Here is my attached solution, Many thanks for your guidance.

Thanks

AJAY

[ajanayak]

Hello Sir,

You are awesome, I did it by taking the help of your approach, Here is my attached solution, Many thanks for your guidance

Thanks

AJAY

[ShankerV · Accepted solution]

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

[ShankerV]

Hi @ajanayak 

++Information

When ever we use Cross tab tool, all the spaces and special characters will be replaced to _

This will cause the column names to change from the original format.

[ajanayak]

Did the changes for Column names as well.

Many thanks.