Need hep for MultiRow tool configuration

[ajanayak]

Hello there,

Please help me as I have some urgent deliverable regarding multirow tool use case wherein I have to update the entire row based on other two row value, Need some help on this, Details are given in the attachment sheet.

Thanks in advance.

[ShankerV]

Hi @ajanayak 

Please find the expected output.

Many thanks

Shanker V

[grazitti_sapna]

@ajanayak , Please find the workflow below. You can use transform tools to get your desired output.

[ShankerV]

Hi @ajanayak 

Step 1: Input

step 2: 

Step 3: 

Many thanks

Shanker V

[ajanayak]

Hello Shanker,

Many thanks for your prompt response, Would you not mind to attach the workflow you have created as resolution.

Thanks

AJAY

[ShankerV]

Hi @ajanayak 

Step 4: Sort tool

Step 5: 

IF [Units Category]="Billing"
THEN [Row+1:Value]-[Row+2:Value]
ELSE [Value]
ENDIF

Step 6:

Expected output

Many thanks

Shanker V

[Christina_H · Accepted solution]

Due to the column names it isn't as simple as it seems to do this with transpose/crosstab tools (which was my first instinct).  Here's a version using the multifield tool.

[ShankerV]

Hi @ajanayak 

I am not able to save the workflow due to this issue.

Give me 5  minutes, will resolve and save the file.

[ShankerV · Accepted solution]

Hi @ajanayak 

Please find the file attached.

[BS_THE_ANALYST · Accepted solution]

Hi, I think I've done what you require! 😀. Attached the workflow for you to try