Calculation for a column based on other row fields value.

Hello Team,

Please help me on my problem which I am facing for my exercise. Need to update a single column value of a row by taking other row fields value,

Everything related requirement is documented in the attachment in Input and Output sheets.

Any help would be highly appreciated.

Thanks

AJAY

InputData.xlsx

Transformation

Preparation

Text Mining

Accepted answers

ShankerV

Hi @ajanayak

Step 1: Input

Step 2: Record ID to keep the format till end

Many thanks

Shanker V

All comments

ShankerV

Hi @ajanayak

You can achieve the solution by below steps.

1. Use the record ID tool.

2. Use dynamic rename tool.

3. Use the Transpose. Multi row formula and then Crosstab back to ge the desired output.

Many thanks

Shanker V

ajanayak

Thanks Shanker,

I tried few things based on our previous solution provided by you and team, but it seems bit difficult to capture the range of (Prior 2 column to next 3 columns), I feel great if you can provide the solution in a WF using the same data provided by me in the attachment.