Skip to main content
Solved

Data points transformation not showing values


Forum|alt.badge.img+2

I am following the instructions on the lesson:

https://learn.cognite.com/path/cognite-data-fusion-fundamentals/working-with-cdf-integrate/865148

 

SELECT 
concat('FirstnameBirthyear:',dp.sensor) AS externalId,
cast(time_stamp/1000 as timestamp) AS timestamp,
cast(value AS double)
FROM IFSDB.values AS dp,
 
--selecting from _cdf.timeseries means we select from the timeseries we ingested to CDF earlier. We do this to make sure all the time series we try to add data points to actually exist
 
_cdf.timeseries AS ts WHERE CONCAT('FirstnameBirthyear:',dp.sensor) = ts.externalId

 

I run the sql query modifying the FirstnameBirthyear values according with my name, but when I apply Preview, it doesn´t show any values. 

The result of the Preview query:

 

The query is syntactically correct, but returned 0 rows of data.

I was expecting to see some values as the other exercises. Is that a normal response on the lesson?

Best answer by Veronica Gutierrez

It was a simple error. The Preview of the first 100 records dont show values 😁. Mistery resolved.

View original
Did this topic help you find an answer to your question?

3 replies

Forum|alt.badge.img+2

It was a simple error. The Preview of the first 100 records dont show values 😁. Mistery resolved.


Dilini Fernando
Seasoned Practitioner
Forum|alt.badge.img+2

Hi @Veronica Gutierrez,

I am glad that you were able to resolve the issue. As of now, I will close this thread. If you have any questions, please feel free to create a post.

Br,
Dilini

 


cmotek
Active
Forum|alt.badge.img+1
  • Active
  • 1 reply
  • May 21, 2024

Can someone explain why Preview 100 doesn’t show any records? I was having the same issue for a few hours until I found this message :)


Reply


Cookie Policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie Settings