Getting Data In

I have a CSV that I import daily and some values decide to not show as "0", and some do.

agoktas
Communicator

I have a CSV that I import daily and some values decide to not show as "0", and some do.

Here's my search:

index="stockscreener_1d_ni"
| stats values(Change ), values(Vol), values(Price) by Symbol
| fillnull value=NULL

Some values under the "Vol" field show up blank, even though the CSV has "0" that should have been the value.

Example of CSV input:

AACS,AMER COMMERCE SOLTNS INC,OTC Pink No Information,0.001500,26.944200,0,Common Stock,USA,Florida

The Vol would be the zero value you see there after 26.944200,

Thanks!

Tags (2)
0 Karma

HiroshiSatoh
Champion

I do not know the cause in the search sentence and the sample log.
Please identify the 0 event not displayed and investigate whether there is a format misalignment or the like.

0 Karma

agoktas
Communicator

Sorry, can you provide more detail in your reply?

Is my post wonky? (shows ok for me - with sample log & search syntax I used).

How do I determine if there is a format misalignment or "the like"?

Thanks.

0 Karma
.conf21 Now Fully Virtual!
Register for FREE Today!

We've made .conf21 totally virtual and totally FREE! Our completely online experience will run from 10/19 through 10/20 with some additional events, too!