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.
Solved! Go to Solution.
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