Create and populate a column using IF conditions

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.

Populate column A based on IF conditions.xlsx

Custom Tools

Dynamic Processing

Text Mining

Accepted answers

Emmanuel_G

Hi @Inactive User ,

Find attached the workflow with all the 4 conditions for one input.

Let me know if there is any concern.

Create and populate a column using IF conditions - 19082022.yxmd

All comments

Emmanuel_G

Hi @Inactive User ,

Do you want something like this ?

Create and populate a column using IF conditions.yxmd

flying008

Hi, @Inactive User

Please see that below.

IF Contains([Concat_New Value], "TERMINATED") THEN "TERMINATED" 
ELSEIF IsEmpty([Concat_Old Value]) && !IsEmpty([Concat_New Value]) THEN "New Employee"
ELSEIF !IsEmpty([Concat_Old Value]) && !IsEmpty([Concat_New Value]) THEN "Update" ELSE Null() ENDIF

录制_2022_07_27_08_04_41_618.gif

unknown

Hi @flying008, are you able to share the workflow please?

unknown

Hi @Emmanuel_G, thank you for the workflow, it's turning out good.

additional conditions.png

I'd like to add these two conditions:

- There are line where the employee has only one or two records. I'd like to classify the Change Type as "Update" instead of "New Employee" if there are less two 2 lines for that employee.

- If the "Pack" under the "Attribute" column has values in both old and new. Then classify the change type as "Transfer".

unknown

Hi @Emmanuel_G, would you be able to integrate all four conditions into one output? The last two additional conditions are being generated separately.

Emmanuel_G

Hi @Inactive User ,

Find attached the workflow with all the 4 conditions for one input.

Let me know if there is any concern.

Create and populate a column using IF conditions - 19082022.yxmd

unknown

Thanks, that's working well. I'm encountering another scenario where i want the grouping of the employees then populating the IDs if they're present.

populate IDs.jpg

populate IDs 2.jpg

Emmanuel_G

Hi @Inactive User ,

Happy to help! Can you please mark this answer above as solution? 🙂

Find attached the solution to this scenario.

Do not hesitate to mark this answer as solution if it helped for this new scenario.

ID employees.yxmd

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

binu_acs

@Inactive User One way of doing this

Multi-Row_0919_1.yxmd

Quick Links

This months top contributors

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177

DanM 167