Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

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

madhurinani
8 - Asteroid

Hello,

Below is my input

GroupAB
000
100
2267418780
477297000
500
6135091770
710260
1029450010
1200
1399173130
1487012554933109
151.47E+080
17271972640

 

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.

3 REPLIES 3
IraWatt
17 - Castor
17 - Castor

Hey @madhurinani,

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

IraWatt_0-1659614268513.png

 

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com 

 

AngelosPachis
16 - Nebula

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

 

AngelosPachis_0-1659614357769.png

 

 

MilindG
12 - Quasar

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

Labels