This message was deleted.
# helps
Slackbot
05/21/2023, 2:19 PMThis message was deleted.
f
Fabian Iwand
05/21/2023, 2:36 PMDid your data change?
d
Dylan Omran
05/21/2023, 2:56 PMI changed the file but the basic calculation is the same.
f
Fabian Iwand
05/21/2023, 3:04 PMWhat's the link to your notebook?
Fabian Iwand
05/21/2023, 3:05 PMAlso, assuming this is DuckDB, are you editing on a different device today?
d
Dylan Omran
05/21/2023, 3:11 PMDylan Omran
05/21/2023, 3:12 PMI uploaded the data as a json and am trying to work with the output from the data table
f
Fabian Iwand
05/21/2023, 3:17 PMyou have NaNs in your coordinates (empty strings in your source data)
🙌 1
Fabian Iwand
05/21/2023, 3:20 PMAs a stop-gap solution you can use the condition
Copy code
WHERE isfinite("longitude") AND "longitude" > 0.149🙌 1
d
Dylan Omran
05/21/2023, 4:01 PMThank you @Fabian Iwand. I wondered if it was to do with those which is why I added the WHERE clause. Strange thing is it worked yesterday. I must be doing something slightly different.
f
Fabian Iwand
05/21/2023, 4:09 PMDid your data change?☝️
I changed the file☝️
😃 1
d
Dylan Omran
05/21/2023, 4:12 PMYes I changed the file, but the field names and data types and method were the same as far as I could tell. Eventually if I look hard enough I'll probably work out that I've done something dopey and missed it.
f
Fabian Iwand
05/21/2023, 4:12 PMright, but surely the contents of your file changed, probably introducing those rows with empty sets of coordinates?
d
Dylan Omran
05/21/2023, 4:14 PMThat could have been it. I only changed it to add some metrics and order the columns to make more sense. I thought it was the same number of rows but you're probably right.
f
Fabian Iwand
05/21/2023, 4:16 PMFile attachments aren't versioned (yet), so you can go back to the first version where you got the query working and see it running (and failing) with the current file.
d
Dylan Omran
05/21/2023, 4:27 PMYeah I tried going back and realised the original file wasn't available. I need to figure out how to make the new file work anyway, which hopefully you've solved for me (too much going on here so I haven't checked yet).