Home
Options

Query which gets input from .csv file -- Weird outcome.

with this query, it is able to extract out the TIME_FASTEST:
http://postimg.org/image/4ouwdimpn/
This (ITNO = 034782) AND MONO = '5890902' is from the third row of a Sample.csv file which has 642 rows.

So, I have MyExtensions as below:
http://postimg.org/image/8znpmh3cb/

With MyExtensions, I get the input from that Sample.csv file. I use "csvData.Count()-639" because I want to extract the first three rows. We can see that the third row with ITNO = 034782
and MONO = 5890902. But why is there zero output as seen below?
http://postimg.org/image/617jcdc2t/

In another same query which is from 16th row of that Sample.csv file, with (ITNO = 039074) AND MONO = '5883318' , it extracts out the TIME_FASTEST as below:
http://postimg.org/image/fvqs7x8a3/

Now, With MyExtensions, I get the input from that Sample.csv file. I use "csvData.Count()-626" because I want to extract the first 16 rows. We see that the 16th row is extracted out with the TIME_FASTEST, as what I need, see below:
http://postimg.org/image/sd643zdp9/

Why is the 16th rows able to be extracted out successfully from the Sample.csv file, while the 3rd row, there is no data extracted out? I am really puzzled on it.

Sign In or Register to comment.