Skip to main content
Answer

Data points transformation not showing values

  • January 8, 2024
  • 3 replies
  • 62 views

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.

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
  • Seasoned Practitioner
  • January 9, 2024

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
  • 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 :)