CDF-learning. Timeseries data transformation missing columns

Forum|Forum|2 years ago
December 7, 2023
2 replies
53 views

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!

Sofie HaugAnswer

Cognite Academy Instructor

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!

Sofie | Cognite Academy

R

Randy ThompsonAuthor

Committed ⭐️⭐️

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.

Sign up

Welcome to Cognite Hub