Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

General Discussions

Discuss any topics that are not product-specific here.
SOLVED

Seperate the sub row

tmocrz001
7 - Meteor

Hi, with this data, is it possible to separate it to each other dynamically?

tmocrz001_0-1674457659597.png

 

Expected output:
100 - Red 
 -120 Tiger

Total - 100 Red

101 - Black

- 102 - Dog

- 103 - Cat

Total - 101 Black

Etc..

 

11 REPLIES 11
ShankerV
17 - Castor

Hi @tmocrz001 

 

Can you please paste the input in the source format.

 

So that the solution can be derived from the expected input format. If I mock up in Text Input, it might be different from actual input via Excel sheet.

 

Many thanks

Shanker V

tmocrz001
7 - Meteor

Here is the input

ShankerV
17 - Castor

Hi @tmocrz001 

 

Please find the expected output.

ShankerV_0-1674460162410.png

 

Note: The workflow used to achieve the solution is attached which can be downloaded to see how the solution works.

 

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

 

Many thanks

Shanker V

 

tmocrz001
7 - Meteor

is this possible even u have many data?

ShankerV
17 - Castor

Hi @tmocrz001 

 

To have the structured output.

 

ShankerV_0-1674460971304.png

 

Use Data Cleansing tool.

 

ShankerV_1-1674460989795.png

 

 

 

 

ShankerV
17 - Castor

Hi @tmocrz001 

 

Please find the same output even if we have more data.

 

ShankerV_0-1674461231816.png

 

Input was:

ShankerV_1-1674461264447.png

 

Many thanks

Shanker V

 

tmocrz001
7 - Meteor

Thanks for the answer. But may I ask what if the rows doesnt have spaces? what will be the identifier that you will use?  

ShankerV
17 - Castor

Hi @tmocrz001 

 

It will be very difficult. That's why I got the inputs of the sample file and then the workflow was built.

 

If there are no spaces, the logic to be used will be very different and very complex too.

 

Many thanks

Shanker V

tmocrz001
7 - Meteor

actually that's my problem, the data doesnt have spaces not like the example i gave 😁

Labels