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.

[Emmanuel_G]

Hi @Inactive User ,

Do you want something like this ?

[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

[Inactive User]

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

[Inactive User]

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

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".

[Emmanuel_G]

Hi @Inactive User ,

Good to know that it works.🙂

Find attached the workflow with these two conditions added in yellow container.

Let me know if there is some issue.

[Inactive User]

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 · Accepted solution]

Hi @Inactive User ,

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

Let me know if there is any concern.

[Inactive User]

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.

 

[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.