Generate new rows with new tasks by name data set

AntlRo

Hello

Is there a tool or a way for the below :

I have a data set as such below currently for a hr company payroll :

Name | Task Name | hours|

John | run | 2 |

John | walk |3 |

Susie | run | 4 |

Susie | walk | 3 |

Susie | Climb |1 |

Susie| Crawl | 1 |

Barry | Run | 5 |

I want the output to create new rows for each name and task and show zero since they had that option but didnt select it in the form ( they truly did 0 hours)

Name | Task Name | hours|

John | run | 2 |

John | walk | 3 |

Jonh | Climb | 0 | -- new row

John | Crawl | 0 | -- new row

Susie | run | 4 |

Susie | walk | 3 |

Susie | Climb |1 |

Susie| Crawl | 1 |

Barry | Run | 5 |

Barry | walk | 0 | -- new row

Barry | Climb | 0 |-- new row

Barry| Crawl | 0 | -- new row

Workflow

Datasets

Tips and Tricks

Custom Tools

Data Investigation

Accepted answers

gautiergodard

Hey @AntlRo

Attaching one way you could do this!

Hope this helps!

combo.yxmd

All comments

gautiergodard

Hey @AntlRo

Attaching one way you could do this!

Hope this helps!

combo.yxmd

DataNath

@AntlRo this is what I came up with. Wasn't going to post it as it's just about identical to @gautiergodard's perfectly viable solution. However, I figured that the lookup table I use is a different approach as this creates a hard list of activities to check against. Whereas, the summarize approach may fall down if you're wanting to check for hours of activities that nobody has logged at all:

This would just rely on you keeping the lookup up to date:

Generate rows of 0 hours for incomplete tasks.yxmd

binu_acs

@AntlRo One way of doing this with the batch macro

Generate_NewRows_1103.yxzp

AntlRo

This is awesome as well thanks!

Quick Links

This months top contributors

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177

DanM 167