Create and populate a column using IF conditions

[Inactive User]

Hello community,

I'm looking to create column A (Change Type) and populate based on these conditions:

- If Column E (New Value)'s cell shows "Terminated", the value for that employee in Column A will populate "Terminated".

- If Column D doesn't show value for multiple rows but has values in Column E, then Column A should indicate "New Employee"

- If Column D & E have values for multiple rows then, populate "Update" in Column A.

I've attached the desire output. Hope it makes sense.

[Luke_C]

Hi @Inactive User 

It looks like you want to use a multi-row tool to fill down the values. Here's a thread that tells you how. Be sure to mark the replies to your post as solutions if they got you what you need.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Use-multi-row-formula-to-copy-down/td-p/439802

[Inactive User]

@Emmanuel_G, I need to correct my previous question, the second column doesn't always have the value at the top. Does the multi row function still work?

[Emmanuel_G]

@Inactive User  No problem

Find attached the solution with this new dataset.

Please do not hesitate to mark the answer as solution if it helped.

[binuacs]

@Inactive User One way of doing this