I’ve tried several possibilities, however without any luck. I would like to retrieve a given date based on its year-week number (both separate columns). Can somebody help me with this?
I have used the manipulation string : string((toInt(substr($column1$,0,2))-1)7+1)+“_”+substr($column1$,length($column1$)-4,4) based on a closed topic. They suggest to use: string(“1_”+$column1$) and date format=e_w_Y to get Monday as the first day, but I can’t get this right.
I think you’re overcomplicating this by trying to copy and paste from that previous topic. Instead I would recommend trying to understand what each step does, then applying those concepts to your own workflow.
When I go through this process, I get this result:
After “String to Date&Time” I’ve included a cutoff to only get data until today. Then I added 12 additional rows. Basically, I need 12 data points in the future and only column “data” should be empty. The other columns (i.e., Year, week and date) must be extended.
I try to do this with “Create Date&Time range” node with a fixed rows (12x) and an interval of 1 week. The reason why i did this to take into account the year transition. However, I am stuck once again since I can’t joint this new table with the table above (no unique columns).
I first tried this with the “missing value” node in the above flow, but it doesn’t take into account a year transition.
Thanks elsamuel, that just worked like magic! In my personal workflow I needed to rename the columns of Extract Date&time similar to my main table first, then it worked just fine!