Creating multiple rows in the same column depending on the condition

[nkrupabd]

Hi I'm trying to create a column Type based on the condition like if the employee is working for Day then there should be a row named days in column type and if the same employee is doing overtime as well we need another row with hours in the same type column and the overtime hours need to be summed and updated in the hours column. could anyone please help me on how do i move forward with this . Attaching an example input and output. Thank you

INPUT

OUTPUT

[RolandSchubert]

Hi @nkrupabd ,

if I got you right, you need an additional column [Type], that has to be calculated depending on the [Overtime] column (if [Overtime] > 0 -> hours, else days).
Then you have to aggregate by Employee and Type, but aggregation seems to be only applied to overtime, not to day shift.

I've created a sample workflow, let me know if it works as expected.

Best,

Roland

[nkrupabd]

Thank you for the response, i just gave an example there are many such conditions which need to be applied and have to be used as each row for each condition in the same column.

IN the example i mentioned the column is TYPE and need rows of the column with days and hours , for same employee there need to be different rows depending on the condition.

[RolandSchubert]

That would lead to a more complex condition (or nested conditions), but it should be no problem using a formula. Could you provide more details or sample data? 

[nkrupabd]

Sure Attaching an example .

example is the input file

example out is how the output is expected to be.

Thank you

[Christina_H]

This actually looks like a simple job for the Transpose tool.

I wasn't sure what your default values should be for days/nights so I've used a sum, but you can change that in the Summarize tool.

[Pravallika20]

Hi @nkrupabd ,

Please try the following steps.

hope this helps

[nkrupabd]

Thank you.