Output Query

[clarrock]

Hi Team,

Here's my input - the null is only once in my table

Code	Name
788	abc
48	def
[Null]	jug
799	ron

How do I output in such a way that any record past that null gets deleted

Output as such :

Code	Name
788	abc
48	def

[grazitti_sapna]

Hi @clarrock, give this a try, I have used multirow formula to give a flag and then you can filter records where flag =0.

If you have a sample dataset you can try on that and mark this post as solution if you are satisfied with the result.

Thanks.