Mutirow tool to dynamically update a range of values within a field

Hi Team

I have a data where I need to update the fields manually based on the position of the keywords

For example, the rows in between Asset and Total Assets should be updated as Assets. the number of rows can vary and the words are not always the same.

I have attached the workflow with the sample data and the desired column output in a text input field.

Thanks in Advance

Multirow to dynamically update the top value till total of that value.yxmd

Dynamic Processing

Text Mining

Accepted answers

binu_acs

@anuninan07

Multirow to dynamically update the top value till total of that value.yxmd

binu_acs

@anuninan07 it is bit tricky, you need some link to connect

Multirow to dynamically update the top value till total of that value.yxmd

All comments

binu_acs

@anuninan07

Multirow to dynamically update the top value till total of that value.yxmd

anuninan07

@binu_acs It works in this case but this colon might not be available in other files. Like I may have asset and total asset but not a common character to link in between. Is there a way to update column values based on the first and the last value

For example between liabilities and total liabilities should be marked as Liabilities.

binu_acs

@anuninan07 it is bit tricky, you need some link to connect

Multirow to dynamically update the top value till total of that value.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703