Changing Row Value

Hi All,

How i can change the row value based on another value in the same row,

Attached is the sample data and i want to achieve that in case of row value (Leave Approval:Not Required) in any cell then should change the value of cell against Leave Approval from No to be NA

Thanks in advance

Data Sample.xlsx

Workflow

Accepted answers

danilang

Hi @Mostafa_Anwar

This was a good one to start off the morning

The topmost path transposes the approval types to find if they're required or not. The second path handles the attachments and transforms them so that each attachment and it's corresponding Y/N value are on one row. This is joined to the top stream to and then Y/N are changed to NA based on the Required/Not Required from the top stream. The rest of the workflow is used to get all the columns back into the proper order. The bottom transpose assigns a column order to all the non-key columns. The final join and subsequent union get the column order for all the fields calculated from the top streams. A final crosstab and dynamic rename and you have

This solution isn't completely dynamic. The leave types and attachments can appear in a order but the work flow is limited to 3 sets of approvals and their corresponding approvals with the column names listed above, since these are used in the Approval Types and Approval Attachments transpose tools. If you need this to be completely dynamic let us know and we'll see what we can do.

Edit: similar to @OllieClarke's second post

Dan

Approvals.yxmd

All comments

paulfound

Hi @Mostafa_Anwar,

Not sure I understand your data set well enough, but to change a value using another value in the same row, you could use a formula tool and an IF statement, something like this:

Good Luck

Mostafa_Anwar

Thanks @paulfound for your respond,

Unfortunately value of No is not fixed in specific column,

In my real data it is not limited to specific column, So my question here how i can create condition based on (in case of Leave approval:Not Required) And Row Value beside (Leave Approval) is No then NA Else [Row Value] endif

Hope that clarifies

OllieClarke

Hi @Mostafa_Anwar

If I've understood you then I think this workflow works:

Hope that helps,

Ollie

rows.yxzp

Mostafa_Anwar

Thanks @OllieClarke for your respond, Just i want to know what is the formula if didn't mention specific field because might be in Field 2 or Field 3 or others.

Really much appreciated.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703