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

[anuninan07]

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

[binuacs · Accepted solution]

@anuninan07 

[anuninan07]

@binuacs  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. 

[binuacs · Accepted solution]

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