Want yo assign values to rows , on the basis of other column rows.

[ferha_jafri]

Hello Experts,

I have a requirement in which I want to alter the rows value on the basis of other Column row value. In the attached workflow, I want the output as in Test column 1 should come in all the rows as it is satisfying the condition. The condition is mentioned in the workflow.

Thanks in advance.

[BrandonB]

You can only update one field at a time (The one chosen in the drop down in this case is "Test"), so you probably want to use two multi-row tools to accomplish this. This would be an example of the first:

[DawnDuong]

hi @ferha_jafri 

I'm not 100% sure I understand your question.

a) Are you asking about calculating that involves different rows in different columns?
If this is the question, you use the Multi Row tool to do that... Just click on the variable button and it will expand the list of variables that you can reference as well as how many rows preceding/following that you want to be able to look back / look forward.

OR

b) are you asking if the formula in the Multi-Row tool is correct? the current formula does not make sense to me..

IF [Col2] = [Row-1:Col2] THEN [Test] = 1 AND [Row-1:Test] = 1 ELSE 0 ENDIF

Can you attach an Excel of input and desired outputs, then it will be easier for other community members to help you.

Dawn.

Dawn.

[ferha_jafri]

In the attachment Sheet1 have the Input, in the Output sheets I want to add Flag as a column which will place 1 for all the rows whose summation comes out to 0. So I want all the rows to be marked as 1 for the satisfied condition.