Hi There,
Another recipe question as Im new to using this tool as opposed to dataflows. When aggregating data in a recipe the options for date fields is to aggregate the data by the dates individual components (year (column1), Month (column2), Day (column2), Epoch Sec (column 4) ect).
This is fine, but after the aggregation I need to perform a calculation based on the full date assigned to that row, I tried converting the epoch sec to a date in the transform node, but running into an error. What is the best way to get the date assigned to that row? If it is converting the epoch can you help me with the logic as I seem to be doing something wrong
Thanks!
who designed the platform this way? ugh it's horrible. making unnecessary transformation steps from breaking up the dates in the aggregate node. the date functions are horrible in CRMA compared to other analytics platforms.
another way is to do a left look up from the original data before the aggregate node (if you have a unique key) to join the date back to the data but why design the platform in such a way that makes your users have to do that in the first place? really... why?
