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

[madhurinani]

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.

[IraWatt · Accepted solution]

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 

[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

[MilindG]

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