Can I concatenate row wise data for processing?

Raghu_s

Hello Folks! 

Am trying to set status flags for a entire table result based on a single column. Below is an example. I wanted to build out a record say Table_status_check which should state success or require rerun based on the overall nature /contents of the Summary_check column in the below table irrespective of the number of records I have in this grid. 

Input:  

Example 1:

Example: 2 

Output:

Example 1: 

Table_status_check

Error in results 

Example 2:

Table_status_check

No errors in results. 

Looks simple but misleading for me.

Need some help! 

Kenda

Hi @Raghu_s

I have attached a workflow that I think should get you what you're looking for. Within the workflow, I showed how the solution would work with both of your examples. I first added a formula to check if the summary check field contained the word error. If it did, I created a new field with a value of 1. If it didn't, I made the new value a 0. This way, you could take the sum of this field and if it's greater than 0, you know there was at least one error. 

Hope this helps!

New Workflow1.yxmd