CDF Fundamentals Discussion

Calculate Delta T :

Click + Add Note, go to Source, and select both of the time series. 

The above lines should be : 

Click + Add Node, go to Source, and select both of the time series.

Please correct the training material.

Thanks

Dev 

Hello, I’m working on the lesson Working with CDF: Consume.  I am having issues with loading the charts section.  Endless loop of failed to load.  Any tips?  Here is a screenshot of what I am seeing.  Thanks

Hi Rahul,

Thanks for the response.  I am able to access the data files in manage data catalog with no issue.  I am logged in to the cdf-fundamentals project as well.  My data sets are named Bernard1977 as seen below:

When navigating to the charts section, I am having issues.  Please see screenshots below. 

First it shows as if its trying to load like this:

And I ultimately receive this after trying to reload;

Any help will be greatly appreciated.  This is the final module prior to certification.

Thanks

Hello Rahul,

I verified that I am using the https in the start of the url.  Here is a snapshot of the browser console.

Hello Rahul,

Thanks for your help!  Attached is a snapshot of the console.  Thanks

Hi @Eniko Farkas, I did, my network was too restrictive when I tried. And once I did I wanted to remove the comment, since I saw there were similar comments as well, which I’ve managed to miss somehow when I first went through the discussion 😅 Thanks for asking 

Hello,

For the Data points step “Transform RAW to Data points” I received the error “Query returned no results. The query is syntactically correct, but returned 0 rows of data.” 

It seems the query does not filter for dataSetId and returns no matches. I changed the query to solve the issue on my end, here are the changes: 

SELECT
  concat('FirstnameBirthyear:',dp.sensor) AS externalId,
  cast(time_stamp/1000 as timestamp) AS timestamp,
  cast(value AS double)
FROM IFSDB.values AS dp
JOIN _cdf.timeseries AS ts 
ON CONCAT('FirstnameBirthyear:', dp.sensor) = ts.externalId
AND ts.dataSetId = '1234567890'

I’m having issue with Build and Consume Fundamentals course, I have competed all modules but the status is registered. I cannot move to the Assessment

Hi I’m getting the following error: Cannot resolve 'Matt1996' given input columns:

Followed by a much longer error message. I’ve followed the instructions as stated, but I’m still getting an error. Any ideas?

Query:

SELECT
concat('Matt1996:',loc) as externalId,
IF(parent_loc='' OR parent_loc IS NULL, '', concat('Matt1996:',parent_loc)) AS parentExternalId,

CAST(lastUpdatedTime AS STRING) AS name,

to_metadata(*) AS metadata,

description AS description,

Matt1996-AvevaNet AS dataSetId
 
FROM `Matt1996`.assets
 

Screenshot:

Hey @Aleksander Poverud, I figured out that the trick is adding AND ts.dataSetId = '1234567890' at the end

here is the full query:

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
and ts.dataSetId = '1234567890'