Solved

CDF-learning. Timeseries data transformation missing columns

  • 7 December 2023
  • 2 replies
  • 31 views

Badge

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.

 

icon

Best answer by Sofie Haug 12 December 2023, 10:18

View original

2 replies

Userlevel 3
Badge +6

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!

 

Badge

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