How to create a row with null values within a defined range

Hello,

Below is my input

Group	A	B
0	0	0
1	0	0
2	26741878	0
4	7729700	0
5	0	0
6	13509177	0
7	1026	0
10	2945001	0
12	0	0
13	9917313	0
14	8701255	4933109
15	1.47E+08	0
17	27197264	0

If you notice, there is no record for Group 3,8,9,16 etc.

How can I add those rows with both values as 0 for column A and B

My group numbers are from 0-500, so any group number missing in the input set, I need to append/create a row with 0 values.

thanks.

Developer

Input

Help

Join

Accepted answers

IraWatt

Hey @madhurinani,

You can use the generate rows tool to create the missing rows like this:

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com

Workflow.yxmd

All comments

IraWatt

Hey @madhurinani,

You can use the generate rows tool to create the missing rows like this:

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com

Workflow.yxmd

AngelosPachis

Hi @madhurinani ,

You can create all groups with a generate rows tool and then use a join tool to see whether a certain group is contained or not in your records. Whatever falls out of one side of the join will be what you have to stack on your dataset

sample_workflow.yxmd

MilindG

@madhurinani I had added couple solution depends on how many values you're missing. Generate tool would be preferable here.

Test Group.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703