Comments
-
Quick update: I made a separate Magic ETL using a dummy dataset so I can share the prompt and data. I am still limiting to 100 rows and only passing through this Job Function you see below with a very simple prompt. Run time is getting close to 2hours now. This prompt is much smaller than my initial testing with 100 rows…
-
Hi all! Thank you for the quick responses! I believe we are getting closer. The floor method did disagree with row1 and row5. The case statement hit the mark for a one year gap. But to throw another wrench in the pile… if the time difference is greater than a year, it doesnt look like the case statement worked as intended.