How to add empty row after each unique value in a field?

[dzyfer]

My data currently looks like this:

Date	Name
2022-11-01	ABC
2022-11-01	DEF
2022-11-01	GHI
2022-11-02	JKL
2022-11-02	MNO
2022-11-03	PQR
2022-11-03	STU
2022-11-03	VWX
2022-11-03	YZ1

I would like it to look like this:

Date	Name
2022-11-01	ABC
2022-11-01	DEF
2022-11-01	GHI
2022-11-02	JKL
2022-11-02	MNO
2022-11-03	PQR
2022-11-03	STU
2022-11-03	VWX
2022-11-03	YZ1

I need an empty row to be inserted whenever the Date differs from the value before it.

[ITWhisperer · Accepted solution]

| appendpipe 
    [| stats count by Date]
| fillnull value=0 count
| sort 0 Date count
| eval Date=if(count>0,null(),Date)
| fields - count

[gcusello]

Hi @dzyfer,

could you share your search?

by default isn't possible, but it's possible to find a workaround.

Ciao.

Giuseppe