Need hep for MultiRow tool configuration

Need hep for MultiRow tool configuration.yxmd

Please find the file attached.

BS_THE_ANALYST

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

190123help3.yxzp

All comments

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.

New Workflow5.yxmd

Step 1: Input

step 2:

Step 3:

Many thanks

Shanker V

Hello Shanker,

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

Thanks

AJAY

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

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.

Multi row billing.yxmd

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

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

Need hep for MultiRow tool configuration.yxmd

Please find the file attached.

BS_THE_ANALYST

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

190123help3.yxzp

Hello Shanker,

I appreciate your help and support, When I implement same step by step process in my WF things are not working, Here I am attaching my WF as a package for your reference, If possible please have a look.

The below screen shot is the place where I am trying to implement the things.

Thanks

AJAY

SEA_Automation_V1.0.yxzp

Many Thanks for your quick help.