Output Issue

[henrygeorge]

Hi Alteryx Team

How do I stop outputting the 0 and delete the extra rows with each run?

Roll No.	Date	Name	Veh	Number
12	16-12-2019	Mark	Car	0
13	17-12-2019	Loki	Bus	0
14	18-12-2019	Steve	Bike	0
15	21-01-2020	Red	Boat	0
[Null]	[Null]	[Null]	[Null]	0
[Null]	[Null]	[Null]	[Null]	0
[Null]	[Null]	[Null]	[Null]	0

I used a formula tool to insert those 0's.

How do I stop at the last field of Roll Number automatically and remove the nulls.

[MarqueeCrew · Accepted solution]

@henrygeorge ,

 please use a filter and check that is not empty or is not null [Roll no.]. 

if you want to get rid of 0's, then where you set them to 0, change it to null(). 

IF number = 0 THEN NULL()

ELSE number

ENDIF

 cheers,

Mark