Skip to main content
Solved

CDF-learning. Timeseries data transformation missing columns


Forum|alt.badge.img

I am following the CDF-learning exercises.  All good until I got to transformation of Time Series data.  I get this error. 

Don’t know what to do to fix.

Have gone back and repeated the steps a few times.

 

Best answer by Sofie Haug

Hi @Randy Thompson 

 

Thank you for your question.  After some investigating I found the minor error causing this! It seems like you selected “Create” instead of “Create or update” in the action field (see screenshot below). I changed it to the correct action and ran it, and it worked perfectly! 

 

I hope you are able to move forward with the rest of your learning journey!

 

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

2 replies

Sofie Haug
Seasoned Practitioner
Forum|alt.badge.img+7
  • Cognite Academy Instructor
  • 161 replies
  • Answer
  • December 12, 2023

Hi @Randy Thompson 

 

Thank you for your question.  After some investigating I found the minor error causing this! It seems like you selected “Create” instead of “Create or update” in the action field (see screenshot below). I changed it to the correct action and ran it, and it worked perfectly! 

 

I hope you are able to move forward with the rest of your learning journey!

 


Forum|alt.badge.img

Thanks.  Good to know.  Funny that I made the same mistake multiple times.  :(

 

I was able to proceed with an SQL hack.  I added the following to the SQL query

false as isString,

false as isStep

 

And that seemed to write data into the columns.

 


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