Rearrange

[Raj]

there is a small confusion i am missing out 

the data needs to be converted from input to output

the required output is

kindly help

[ShankerV · Accepted solution]

Hi @Raj 

Please find the below solution. the workflow is very dynamic where we need to add only input.

If this helps, please like this post and mark it as a solution. If you have any other questions, please let us know.

Many thanks

Shanker V

[ShankerV]

Hi @Raj 

Step 1: Input

Step 2: select tool

To increase the size of the string

Step 3: Regex formula

Step 4; Multi row formula tool

if [Matched]=1
then [Field1]+"-"+[Row-1:Field1]
else [Field1]
endif

Step 5: 

If this helps, please like this post and mark it as a solution. If you have any other questions, please let us know.

Many thanks

Shanker V

[ShankerV]

Hi @Raj 

Step 6: Cross tab tool from T node of Filter

Step 7: Cross tab tool from F node of Filter

step 8: Text to columns tool

step 9: Join tool

Step 10: Formula tool

Step 11: Union tool

Desired output after run:

If this helps, please like this post and mark it as a solution. If you have any other questions, please let us know.

Many thanks

Shanker V